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