Interested to Buy Any Domain ? << Click Here >> for more details...
how to rename the table
- 3 Answers
- 7338 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajkumar
SP_RENAME 'OLDTABLE NAME', 'NEW TABLE NAME'
eg:
SP_RENAME 'TBL_EMPLOYEE', 'TBL_EMP'
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / vishal
Rename a table using sp_rename
sp_rename <Old Table Name>, <New Column Name>
Rename a column using sp_rename
here as third argument we have to provide column. default
third argument for sp_rename is table.
sp_rename <table name>.<old Column Name>, <New Column Name>,
'column'
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / mohan
Rename a table
This example renames the customers table to custs.
EXEC sp_rename 'customers', 'custs'
B. Rename a column
This example renames the contact title column in the
customers table to title.
EXEC sp_rename 'customers.contacttitle', 'title', 'COLUMN'
| Is This Answer Correct ? | 0 Yes | 2 No |
What are the new features in sql server 2016?
Explain different types of lock modes in sql server 2000?
What is the importance of three tier architecture?
what is datawarehouse?
You want to implement the many-to-many relationship while designing tables. How would you do it?
what is victor class
What is the use of @@spid?
what is the primary use of the model database? : Sql server administration
Explain the different types of backups available in sql server? : sql server database administration
What is service broker?
What are the types of database recovery models?
How to find index size for each index on table?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
