Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Column default value
- Thread starter mtawk
- Start date
swampBoogie
Programmer
SQL server has a nonstandard syntax for setting a default value for an existing column
alter table tableName
add constraint constraintName
default 'defaultValueExpression'
for columnName
alter table tableName
add constraint constraintName
default 'defaultValueExpression'
for columnName
- Status
Similar threads
