SP_RENAME '<table_name>.<old_column

HOW TO RENAME A COLUMN NAME

Question Posted / ram&saran

Answer Posted / ram&saran

SP_RENAME '<table_name>.<old_column_name>','<new_column_name>'

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How exceptions can be handled in sql server programming?

1012

Define inner join in sql server joins?

1058

Explain the difference between functions and stored procedures in sql server?

978

Explain indexed views and partitioned view with their syntax.

1146

What is PROJECTION Operation?

1020

What is the difference between deallocate cursor and close cursor?

1258

Explain what is sql server english query?

1051

Explain what is public role in sql server?

1133

Explain about builtinadministrator?

1053

what is denormalization? : Sql server database administration

923

What are the steps to process a single select statement?

942

How do you make a trace?

1024

What is the concept of optimization?

1060

Explain primary key, foreign key and unique key?

992

Can We Use Data-grids For Our Report In Ssrs?

184