Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform ... ID('SalesHistory') > 0 DROP TABLE SalesHistory GO CREATE TABLE SalesHistory SaleID ...

SQL is neither the fastest nor the ... and to preserve relational integrity that field should have a foreign key constraint. For example: CREATE TABLE Orders ( OrderID int NOT NULL PRIMARY KEY, ...