If you try to truncate a table that is referenced by foreign key you usually get the following error:
Cannot truncate table 'TableName' because it is being referenced by a FOREIGN KEY constraint.
To avoid this error the easiest way to use DELETE without where clause and RESEED the identity:
DELETE FROM AccVoucher
DBCC CHECKIDENT (AccVoucher, RESEED, 0)
10 Best AI Coding Tools in 2025 to Code Smarter, Faster, and Error-Free
-
The era of AI-assisted coding has arrived—and is the year it goes
mainstream. From writing full functions to debugging and documenting
complex projects,...
2 weeks ago


No comments:
Post a Comment