How can I drop a table if there is a foreign key constraint in SQL Server? 1. Ağustos 2016 Can (0) The Best Answer to dropping the table containing foreign constraints is : Step 1 : Drop the Primary key of the table. Step 2 : Now it will prompt whether to delete all the foreign references or not. Step 3 : Delete the table.