Remove constraint

ALTER TABLE String target_table DROP CONSTRAINT String constraint_name;

Description

Removes a constraint from a table

Arguments

String target_table

The table you wish to remove the constraint from.

String constraint_name

The name of the constraint on the table.

Examples

Example 1

This command will drop the constraint from users

ALTER TABLE users DROP CONSTRAINT pk_users;