Wednesday, March 21, 2012

Drop table - not possible

Hi!

I wish to drop a table on sql server 2000, but SS2K will allow it because of table's dependencies.

Is there a way to drop the table (I don't care about dependencies)? I just want to drop it!

thanks.

FaN
You have to care about dependencies like constraints, Statistics, DRI(declarative referential integrity), Views and indexes because if you have any of the above you cannot drop the table because SQL Server uses the relational model which means all related items must be removed before items in the relation can be dropped because of data integrity issues.|||

Easy.

First, remove all of the dependencies.

Second, DROP the table.

No comments:

Post a Comment