SQL Server allows you to define cascading ... This specifies that if an update or delete statement affects rows in foreign key tables, the action will be denied and rolled back.

what's the best way to delete all the subfolders and subfiles, recursively? I'm writing this app in ASP.NET/C#, with a MySQL backend. Should I set up a foreign key constraint? How would I go about ...