SP_Rename 'dbo.table_name.column_name','new column

HOW TO RENAME A COLUMN NAME

Question Posted / ravikv

Answer Posted / ravikv

SP_Rename 'dbo.table_name.column_name','new column_name'.

Is This Answer Correct ?

27 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are the features of Embedded SQL

1133

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1016

Define indexes?

1050

Can you get second highest salary from the table?

966

What is index in an assignment?

955

What is ddl command?

986

What is the primary use of the model database?

1087

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

908

Explain the xml support sql server extends?

1043

What is a covering index?

987

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1010

Indexes are updated automatically is the full-text index also updated automatically?

1031

What is sql server database?

1016

How to disable a login name in ms sql server?

1135

When to use Inner join & when to use subquery?

1166