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
What is NOT NULL Constraint in sql server 2012?
Explain how many normalization forms?
what is an extended stored procedure? : Sql server database administration
how to avoid cursors? : Sql server database administration
What is the difference between the application object and session object?
What is difference between foreign key and unique key?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What are distinctive joins find as a part of sql?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is data mart? : sql server analysis services, ssas
What is function of CUBE ?
Explain the creation and execution of a user-defined function in the sql server?
Explain aggregate functions?
How to modify an existing user defined function?
What does set rowcount do?
