how to rename the table
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 |
Write a code to select distinct records without using the DISTINCT keyword.
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is The Use Of TIMESTAMP DataType in SQL Server 2005?
Can you give an example of Stored Procedure?
Give me a SQL Query to find out the second largest company?
Explain boyce and codd normal form(bcnf)?
How to delete duplicate rows in sql server?
Explain a differential backup?
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>
how to determine the service pack currently installed on sql server? : Sql server database administration
What are the security related catalog views? : sql server security
Working with TLogs
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)