How can i change the column name.

Answer Posted / sanjay

ALTER TABLE tablename CHANGE oldname newname varchar (10) ;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between stored procedure and view in sql server?

627


What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

631


Do you know what is sql service broker?

538


What triggers long term care?

565


Can a table have 2 foreign keys?

507






What is query parameter in ssrs?

118


what data regions are and what are the different data regions?

101


What are cursors stored procedures and triggers?

517


How do I port a number to sql server?

504


What are the different Authentication modes in SQL Server and how can you change authentication mode?

644


What are the differences between ms sql server & oracle?

529


What is the difference between SQL notification and SQL invalidation?

592


Explain datetime2 data type in sal server 2008?

549


Why are views required in the sql server or in any other database?

538


What is partitioned view?

527