Collections:
"sp_rename ... 'OBJECT'" - Renaming Existing Tables in SQL Server
How to rename an existing table with the "sp_rename" stored procedure in SQL Server?
✍: FYIcenter.com
If you have an existing table and you want to change the table name, you can use the "sp_rename ... 'OBJECT'" stored procedure. "sp_rename" allows you to change names of COLUMN, DATABASE, INDEX, USERDATATYPE, and OBJECT (including tables). The tutorial example below shows you how to rename a table:
sp_rename 'tip', 'faq', 'OBJECT' GO Caution: Changing any part of an object name could break scripts and stored procedures. SELECT name, type_desc, create_date FROM sys.tables GO name type_desc create_date faq USER_TABLE 2007-05-19 23:05:43.700 tipBackup USER_TABLE 2007-05-19 23:25:23.357
You can also rename a table with on the Object Explorer window of SQL Server Management Studio. See tutorials on rename table columns.
⇒ "DROP TABLE" - Deleting Existing Tables in SQL Server
⇐ "ALTER TABLE ... ALTER COLUMN" - Changing Column Data Type in SQL Server
2016-11-15, 2232🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...