SQL Server disables enabling triggers, FOREIGN KEY constraints

--enable or disable all foreign KEY constraints on the specified tableAlter TableTbnameNOCHECK constraint  All  Alter TableTbnameCHECK constraint  All--View ConstraintsSelectName, is_disabled fromSys.foreign_keysOrder  byname--DisabledALTER TABLETbname DISABLETRIGGERTrigname--RecoveryALTER TABLETbname ENABLETRIGGERTrigname--disable all triggers on a tableALTER TABLETbname DISABLETRIGGER  All --to enable all triggers on a tableALTER TABLETbname ENABLETRIGGER  All

--Add primary KeyAlter TableTbnameAdd constraintPk_namePrimary Key(COLUMN1,COLUMN2)--To add a nonclustered primary keyAlter TableTbnameAdd constraintPk_namePrimary Key nonclustered(COLUMN1,COLUMN2)--Delete primary KeyAlter TableTbnameDrop constraintPk_name

 --  add foreign key   table  tbname add  constraint  fk_name key  ( Fk_column) references   Pk_tbname (Pk_column)  --  delete foreign key   table  tbname drop  constraint  fk_name 

-- Add a UNIQUE constraint Alter Table Add constraint Unique (colname)