Advanced Search

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.

Highlighted TextExpand

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.