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
What are the different types of columns types constraints in the sql server?
How do we synchronize On-Premise SQL server with SQL Azure?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Explain primary key in sql server?
How is SQL Azure different than SQL server?
What is a View ? Can we insert, Update and delete a view?
Explain about system database?
Is it possible for a stored procedure to call itself or recursive stored procedure?
List out some of the requirements to set up a sql server failover cluster?
Using the customer, and order table in northwind database, please write a query to produce xml?
what are constraints? : Sql server database administration
What are the advantages of partitioning?
What is an expression in ms sql server?
When should you use an instead of trigger?
Can you pass expressions to stored procedure parameters?