Disable foreign key constraint for all tables does not work

Question

I try many commands to disable table restrictions in my database, to truncate all tables, but still now it gives me the same error:

Cannot truncate table '' because the FOREIGN KEY constraint refers to it.

I'll try

EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
EXEC sp_MSforeachtable "TRUNCATE TABLE ?"

And I tried this for every table

ALTER TABLE [Table Name] NOCHECK CONSTRAINT ALL  
truncate table [Table Name]
ALTER TABLE [Table Name] CHECK CONSTRAINT ALL

and every time I have a previous error message. How can I solve this problem?

+3

Amr badawy Mar 20 '10 at 7:33

2 answers

, . SQL- .

?

() , , SSIS ( , COPY DATA) False

+1

Ashish Gupta · Accepted Answer · 2010-03-20T07:54:43+0000

If you want to truncate the table, you may need to reset the foreign keys and add them back. From here .

" TRUNCATE TABLE , FOREIGN KEY, DELETE WHERE. TRUNCATE TABLE , ."

SO.