how to remove and add foreign key in mysql for truncating table code example Example: mysql remove foreign key constraint ALTER TABLE jobs DROP FOREIGN KEY constraint_name