Lazzycoder Code For Everyone

Have a Question?

If you have any question you can ask below or enter what you are looking for!

    TRUNCATE TABLE with foreign keys

    29-12-2015 17:40:07 MSSQL / Operation 0 Bookmark(s) 188 View(s)

     

    Truncating a table is the fastest way to remove all rows. But is is not possible if foreign keys have been defined. You can get around this limitation by setting FOREIGN_KEY_CHECKS to 0.

    
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE [Schema].[Table]; 
SET FOREIGN_KEY_CHECKS = 1;