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, 2258🔥, 0💬
Popular Posts:
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...