HOW TO RENAME A COLUMN NAME

Answer Posted / ravikv

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

Is This Answer Correct ?    27 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a view and what are its advantages?

757


What are policy management terms?

636


What is the difference between stored procedure and user defined functions?

719


How do you delete duplicate rows in sql server?

574


How to enter binary string literals in ms sql server?

702






What is t-sql script to take database offline – take database online.

690


What is an identity column in insert statements?

653


where the connection string store in the database

1626


How to download microsoft sql server 2005 express edition?

683


What is the difference between a function and a stored procedure?

659


what are the different ways to return the rowcount of a table?

661


How do I create a stored procedure in dbml?

604


When we should use and scope of @@identity?

630


Write query to return all rows sql?

692


Explain intellisense for query editing

666