when to drop table when using foreign keys code example

Example: drop foreign key

ALTER TABLE table_name
DROP CONSTRAINT fk_name;