add a column to an existing table

• Betty Sun

  SSCrazy

  Points: 2442

  More actions

  July 8, 2008 at 12:06 pm

  #193530

  Hi all,

  I have the following:

  alter table clients

  Add column SceneFlag [char](1) NOT NULL DEFAULT 'Y'

  I always get the following message:

  Msg 156, Level 15, State 1, Line 2

  Incorrect syntax near the keyword 'column'.

  I don't get it. where did it go wrong.

  Betty

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  July 8, 2008 at 12:14 pm

  #839712

  Double posted.

  See this link: http://www.sqlservercentral.com/Forums/FindPost530278.aspx

  😎

• Betty Sun

  SSCrazy

  Points: 2442

  More actions

  July 8, 2008 at 12:38 pm

  #839729

  sorry to bother you all.

  I got it. I somehow add "column" key word. I removed and everything works fine.

  Sincerely

  Betty