Example 1: Renaming of table
old_table_name: persons
new_table_name: people
old_table_name: persons
After execution of query,
After execution of query, new_table: people
SQL Server Rename Table
In SQL Server, renaming tables is a frequent operation that we often require during database maintenance or schema changes. This article ensures your seamless transition through the table-renaming process without compromising data integrity. it provides comprehensive guidance and guarantees protection for your valuable information – all in pursuit of an unimpeachable database management strategy.
Prerequisites:
- Permissions: The table belongs to a schema, and you must possess ALTER permission on that specific schema.
- Backups: It is advisable: before implementing any structural modifications, to take a backup of the database to safeguard data integrity.
Syntax:
sp_rename ‘old_table_name’, ‘new_table_name’
This procedure allows to change the name of a table while preserving structure, associated constraints, indexes, and triggers.
Contact Us