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


Please Help Members By Posting Answers For Below Questions

Ways to improve the performance of a SQL Azure Database?

103


What are the common performance issues in sql server?

493


How to connect to a sql server using odbc_connect()?

609


Explain a join?

602


how you can configure a running aggregate in SSRS?

112






Is mysql the same as sql server?

503


What command must you use to include the not null constraint after a table has already been created?

538


you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

527


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1750


What is the difference between ddl and dml?

559


What is the difference between locking and multi-versioning?

522


What are the steps you should follow to start sql server in single-user mode?

474


How can we rewrite sub-queries into simple select statements or with joins?

519


In what three ways is the return statement used in a stored procedure?

510


What is a print index?

490