Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rename Table?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Rename Table?
Divers
Thread ID:
00943527
Message ID:
00943527
Vues:
56
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.
James Harvey, MCP
Memphis Police Department
225 Channel Three DR
Memphis, TN 38103
901 577-1296
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform