• There are plenty of scripts available to check for foreign key constraints and disable them, truncate then re-enable them. Also you should be aware of the difference between the truncate and delete commands.

    Do a google search like 'delete relation ships then truncate table'