Answer Posted / 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 |
Post New Answer View All Answers
How exceptions can be handled in sql server programming?
What are built in functions?
What is the difference between count () and rowcount ()?
How to make a column nullable?
What is the osql utility?
Does sql server 2000 clustering support load balancing?
How do you manipulate data?
What is coalesce in sql server?
Explain “@@rowcount” and “@@error” in sql server?
What is oltp (online transaction processing)?
Explain nested trigger in sql?
What is a dbms wizard?
Explain different types of index?
How can we get count of the number of records in a table?
What is difference between commit and rollback when used in transactions?