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...
https://www.czetsuyatech.com/2021/07/mssql-select-all-triggers_02029201135.html
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