changing a column name differs from the type of database we use. MySQL:

How can we change the name of a column of a table?

Question Posted / nithya

7 Answers
10919 Views
I also Faced
E-Mail Answers

Answer Posted / nithya

changing a column name differs from the type of database we use.

MySQL:
ALTER table customer CHANGE Address Addr char(50);

Oracle:
ALTER table customer RENAME COLUMN Address TO Addr;

SQL Server:
It is not possible to rename a column using the ALTER TABLE
statement in SQL Server. Use sp_rename instead.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

In which year mysql created?

973

Is mariadb faster than mysql?

964

Explain csv tables.

1009

What are the different types of triggers in mysql?

963

How do I start and stop mysql on windows?

1008

What are the different tables present in MySQL?

1113

What is a select query?

853

How to use like conditions?

985

What are the technical features of MySQL?

1011

What is mysql server?

1081

How do I show columns in mysql?

929

What is mysql and mysqli?

929

Explain the different types of constraints?

946

Where is mysql installed on linux?

920

Is mysql a free database?

938