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 ...

Should I set up a foreign key constraint? How would I go about doing this within a table (to tie the parentid field to the folderid field)? Would it cascade through multiple levels? I.e. For the ...