How can i change the column name.
Answer Posted / kinthada cnu
hi all
sp_rename 'tablename.oldcolumnname','newcolumnname','column'
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What method is used by the Command classes to execute SQL statements that return single values?
What are the different authentication modes in sql server? How can it be changed?
How to generate create function script on an existing function?
Can we take the full database backup in log shipping?
Name few of the dcl commands in sql?
How to fine-tune reports?
Explain left outer join and right outer join?
What do you need to connect php to sql server?
What is the difference between row_number and dense_rank?
What is an inner join?
What’s the distinction between dropping a info and taking a info offline?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is the difference between mysql and mysqli?
Which is the main third-party tool used in sql server?