How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Answer / Ankit Awasthi
"To rename an existing column using the sp_rename stored procedure in MS SQL Server, follow these steps:n1. Open SQL Server Management Studio (SSMS) or any other query tool.n2. Use the sp_rename system stored procedure and provide the old column name, the new column name, and the table name as parameters.n3. Execute the command to rename the column."
| Is This Answer Correct ? | 0 Yes | 0 No |
What are policy management terms?
What is cursors? And what are the different types of cursor?
How can I create a report based on a query? : sql server management studio
What is the difference between NOROW and LOCKROW?
1 Answers Accenture, Honeywell, Satyam,
What are the 10 characteristics of data quality?
Mention the differences between local and global temporary tables.
How do I delete a sql server database?
How do I view a procedure in sql server?
What is resultset concur_updatable?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
How do I determine how many instances of sql server are installed on a computer?
how to find out the repeated value from table using groupby function?
Oracle (3253)
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)