no

How to alter bit and date column's default value in MSSQL

Aside from using the SQL Designer, you can alter a bit and date column's default value. ALTER TABLE TableName ADD CONSTRAINT TableName...

Aside from using the SQL Designer, you can alter a bit and date column's default value.
ALTER TABLE TableName ADD CONSTRAINT TableName_Disabled DEFAULT 0 FOR Disabled
ALTER TABLE TableName ADD CONSTRAINT TableName_DateCreated DEFAULT getdate() FOR DateCreated
To list the constraints created you can invoke:
EXEC sp_help TableName

Related

database 7731490848949073398

Post a Comment

item