Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Drop table won't work because of foreign key


Message #1 by "Dean" <spinout@i...> on Wed, 16 Jan 2002 17:55:17
ALTER TABLE tablename DROP CONSTRAINT foreignkey_constraintname

-----Original Message-----
From: Dean [mailto:spinout@i...]
Sent: Wednesday, January 16, 2002 9:55 AM
To: sql language
Subject: [sql_language] Drop table won't work because of foreign key


I want to drop a table but it won't let me because I have a foreign key
linking it to another table.
How do I drop the foreign key??
$subst('Email.Unsub').

  Return to Index