SQL Server Performance Forum – Threads Archive

unable to drop table

Hi!
When I am trying to drop table from a db I am unable to do so and got the following errors for one table i got "conversion invalid for datatypes on column pair 4"
for another tbl i got "destination does not allow null null on column pair 1"

---

DROP TABLE cannot be used to drop a table referenced by a FOREIGN KEY constraint. The referencing FOREIGN KEY constraint or the referencing table must first be dropped. Another run DBCC CHECKTABLE TABLE_NAME Check if any DTS task is going on using this table.. while you are deleting it Deepak Kumar –An eye for an eye and everyone shall be blind

---

sp_help tablename
will give you the list of foreign keys which associated with given table . first drop them b4 droping the table.

---

sp_fkeys ‘TableName’ will be also useful
Madhivanan Failing to plan is Planning to fail

---

]]>