One thing that I forgot to mention. The data that we load is grouped by year. That is we get a set of data for 2003, 2004, 2005,...

Great feedback. Thanks everyone.

Here's the reason why I want to use truncate:

We have a database refresh job that happens weekly. The job basically deletes all rows from all...

Is there a way to get all the DDL for all constraints on a table?  Then I could run the drop all the constraints on the table, run the truncate,...