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

When would you use the stored procedures or functions?

567


What happens when the SQL Azure database reaches Max Size?

90


How to download and install microsoft .net framework version 2.0?

542


What are different types of table joins?

551


What is the full form of dql?

503






What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

690


Mention the 3 ways to get a count of the number of records in a table.

544


Explain sql server service broker?

503


What is tablix?

115


How do I create a trace in sql server?

509


How to list all field names in the result set using mssql_field_name()?

517


What are cursors stored procedures and triggers?

506


how you can get the list of largest tables in a database? : Sql server administration

542


Explain filtered indexes?

545


How do I manually uninstall an instance of sql server 2016?

539