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, 2356🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...