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)
Perplexity vs ChatGPT – Which Is Better According to Industry Experts
-
Perplexity AI Pro and ChatGPT aren’t just competing tools—they represent
two different philosophies shaping the future of how we work. One is
redefining...
1 week ago

No comments:
Post a Comment