To drop a constraint, you can use the DROP keyword. Here are some examples of modifying or dropping constraints: -- Add a foreign key constraint to the ORDER table ALTER TABLE ORDER ADD CONSTRAINT ...