alter table (table_name) change (old_colomnname)(new

How can i change the column name.

Question Posted / dipti sonawane

Answer Posted / dipti sonawane

alter table (table_name)
change (old_colomnname)(new_colomnname)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Tell me what is the order in which the sql query is executed?

956

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1140

what is package and it uses and how can u call a package

2017

How to connect Azure federated root database and apply federation in entity framework?

107

What is the log shipping?

1014

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

1161

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1068

What is postgresql server?

1009

What do you mean by 'normalization'?

1068

What is difference between stored procedure and user defined function?

1115

How to execute the cursor queries with "open" statements?

1185

What are scheduled tasks in sql server?

1090

How to delete an existing row with delete statements in ms sql server?

1099

If a stored procedure is taking a table data type, how it looks?

6452

What is the use of “join” in sql server?

1104