How can i change the column name.
Answer Posted / kshirsagar sambhaji
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is log shipping?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
Describe how to use linked server?
What is change data capture (cdc) feature?
Explain the rules for designing files and file groups in sql server?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How can I get data from a database on another server?
When we should use @@error?
Explain different types of index?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Define full outer join in sql server joins?
What is the use of partition by in sql server?
What are the different types of data sources in ssrs?