Truncate a table that has foreign keys referencing its columns

This stored procedure will truncate a table even when other tables have FKs referencing columns in it. It drops the Fks, truncates the table, re-creates the FKs

QOTD Truncating Identity

Truncate Table

Remove data from tables

Truncate Table

What will the max id be?

Table Variable

T SQL

Grant Truncate Table Permissions in SQL Server without ALTER Table

How do you grant a SQL Server developer truncate table permission without giving them the ability to alter the table? Check out the examples and explanation in this tip.

Truncate Transaction - All Databases

Script to help you to truncate TL for all databases.