>My question is : Is it better to issue a Truncate table statement to empty out the existing table or drop it and re-create it ? Is there an advantage or disadvantage of using either method ?
You could go for the obvious: if you drop the table, you'll have to recreate not only the table but also all of the indexes, constraints, and permissions.
I think I'd look at truncate it.
-Mike
>Hi All,
>
>I need an advise. I'm writing a stored procedure in SQL2000 that will be used in overnight process to re-create sales table based on couple of tables from another database.
>
>My question is : Is it better to issue a Truncate table statement to empty out the existing table or drop it and re-create it ? Is there an advantage or disadvantage of using either method ?
>
>Thank you,
>Daniel