When you try to delete the Primary table in tables that have a Primary Key Foreign Key relationship, you receive the error as follows. To delete a Primary table without an error, you must first delete the foreign table.
Could not drop object ” because it is referenced by a FOREIGN KEY constraint. (.Net SqlClient Data Provider)