Brackets in a create table statement

• Mark Green

  SSCrazy

  Points: 2085

  More actions

  August 3, 2006 at 7:01 am

  #114061

  In a create table statement what is the difference between:

  CREATE TABLE Table

  _name (

  and

  CREATE TABLE [Table

  _name] (

• Deepak R-352629

  Newbie

  Points: 4

  More actions

  August 3, 2006 at 7:06 am

  #653074

  Square brackets are used to make DBMS understand that do not treat the word as reserved word used by DBMS, if it is a SQL reserved word.

• David.Poole

  SSC Guru

  Points: 76000

  More actions

  August 3, 2006 at 7:25 am

  #653082

  In other words it allows you to use worst practices

  LinkedIn Profile