no

How to Select All the Triggers in an Mssql Table

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

rdbms 7731490848949073398

Post a Comment Default Comments

item