KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm changing constraints in my database and I need to drop some of them. I know that for a single constraint, the command is following: ALTER TABLE tblApplication DROP CONSTRAINT constraint1_name; However, when I try ALTER TABLE tblApplication DROP ( CONSTRAINT constraint1_name, CONSTRAINT constraint2_name, CONSTRAINT constraint3_name ); it doesn't work and I need to do: ALTER TABLE tblApplication DROP CONSTRAINT constraint1_name; ALTER TABLE tblApplication DROP CONSTRAINT constraint2_name; ALTER TABLE tblApplication DROP CONSTRAINT constraint3_name; Is there a way to remove more than one constraint in a single command? I'd like to avoid repeating ALTER TABLE tblApplication , just like with the ADD command: ALTER TABLE tblApplication ADD ( CONSTRAINT contraint1_name FOREIGN KEY ... ENABLE, CONSTRAINT contraint2_name FOREIGN KEY ... ENABLE, CONSTRAINT contraint3_name FOREIGN KEY ... ENABLE );
Tags (comma-separated)
Save Edits
Cancel