T-SQL-Adding a column to a table

• getitimped

  SSC Journeyman

  Points: 98

  More actions

  October 22, 2009 at 12:27 pm

  #156341

  Here is the script:

  ALTER TABLE password

  ADD COLUMN Domain varchar(50) NOT NULL

  GO

  Keep getting as a result:

  Msg 156, Level 15, State 1, Line 2

  Incorrect syntax near the keyword 'COLUMN'.

  I've noticed that none of these work (ADD COLUMN, ALTER COLUMN) in SQL. What am I missing?

  Thanks,

  Jeff

• George M Parker

  SSCertifiable

  Points: 5412

  More actions

  October 22, 2009 at 12:36 pm

  #1069602

  You don't need the word COLUMN.

  ALTER TABLE passoword

  ADD Domain varchar(50) NOT NULL

  GO

  If there's already data in the table, you won't be able to add the NOT NULL column unless you also supply a default value for it.