Enable or Disable a Constraint
-- Enable all table constraints
ALTER TABLE <table_name> CHECK CONSTRAINT ALL
-- Disable all table constraints
ALTER TABLE <table_name>NOCHECK CONSTRAINT ALL
-- Disable a specific constraint
ALTER TABLE <table_name>NOCHECK CONSTRAINT <constraint_name>
-- Enable a specific constraint
ALTER TABLE <table_name>CHECK CONSTRAINT <constraint_name>
0 Comments:
Post a Comment
<< Home