Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain ... 0 DROP TABLE SalesHistory GO CREATE TABLE SalesHistory SaleID int IDENTITY ...

The script has been tested on SQL Server 2005 and SQL Server 2008 R2 ... The basic approach is to TRUNCATE each table, dropping and re-creating foreign key constraints and associated extended ...