James,
Check sp_rename system sproc.
>Is there a way to rename a SQL table from a Stored Procedure?
>
>I have a production table [TNDL]. I want to populate a temporary table [TEMP] with 6 million records, truncate the Production table [TNDL], then rename the Production table from [TNDL] to [DELETED], rename the [TEMP] table to [TNDL], then rename the [DELETED] table to [TEMP] so I can do it again next month.
--sb--