column name standards in sql server 2005

• basam nath

  SSC Enthusiast

  Points: 110

  More actions

  December 20, 2006 at 10:11 am

  #175299

  I tried to create a table with create column name as "LEVEL" in sql server 2005 .

  The sql server automatically add square brackets around that word for some reason. Is Level a keyword in sql server?

  thanks

  nath

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 20, 2006 at 10:50 am

  #679175

  Yes, LEVEL is the one of the keyword...

  See the current and future key words list...

  http://msdn2.microsoft.com/en-us/library/ms189822.aspx

   

  MohammedU
  Microsoft SQL Server MVP