SQL - SQL Server - Add Column with Default Value and Check Constraint


/ Published in: SQL
Save to your folder(s)

Example of SQL syntax to add a new column to an existing table, define a default value to the columns for the existing rows and also add a check constraint to limit the values that the column can hold.


Copy this code and paste it in your HTML
  1. ALTER TABLE
  2. GhibliMovies
  3. ADD
  4. Director VARCHAR(255) NULL
  5. CONSTRAINT
  6. director_check CHECK (Director IN ('Hayao Miyazaki', 'Isao Takahata', 'Yoshifumi Kondo', 'Goro Miyazaki', 'Hiromasa Yonebayashi'))
  7. DEFAULT
  8. 'Hayao Miyazaki' WITH VALUES;

URL: http://msdn.microsoft.com/en-us/library/ms190273.aspx

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.