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 to create new table with "create table" statements?
What is 'write-ahead log' in sql server 2000 ?
When I delete any data from a table, does the sql server reduce the size of that table?
what is raid and what are different types of raid configurations? : Sql server database administration
What are .mdf files?
What are types of storage modes? : sql server analysis services, ssas
How to locate and take substrings with charindex() and substring() functions?
What do you mean by 'normalization'?
What is SQL Azure Firewall?
What is the use of set nocount on/off statement?
What is a linked server in sql server?
How to use union to merge outputs from two queries together in ms sql server?
How do you drop an index?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
Difference between Sql server reporting services and Crystal reports?