Drop a constraint
- Basic example
ALTER TABLE <table_name> DROP CONSTRAINT already_existing_constraint;
- To avoid an error if the constraint does not exist
ALTER TABLE <table_name> DROP CONSTRAINT IF EXISTS already_existing_constraint;
ALTER TABLE <table_name> DROP CONSTRAINT already_existing_constraint;
ALTER TABLE <table_name> DROP CONSTRAINT IF EXISTS already_existing_constraint;