I'm trying to do a Truncate table
ALTER TABLE txoCheckDetails NOCHECK CONSTRAINT ALL
TRUNCATE TABLE txoCheckRequest
but am getting the following error.
Cannot truncate table 'txoCheckRequest' because it is being referenced by a FOREIGN KEY constraint.
So my questions is sinze I am diabling the only foriegn key constraint on the table it will not let me Truncate the table. I can do a DELETE on the table and remove everything, but how come I can't do a truncate.