Answer / vipul dalwala

ALTER TABLE table_name change OLD_COLUMN_NAME
NEW_COLUMN_NAME VARCHCHAR(100) NULL;

Answer / tushar

ALTER TABLE table_name change OLD_COLUMN_NAME
NEW_COLUMN_NAME VARCHAR(255) NULL;

Answer / 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.

Answer / shweth

we can use ALIAS function for this
select tree AS plant
from table;
or simply we can skip writing AS but shoudnt write a comma
between the old and new column names.

Answer / owais masood

RENAME cannot be used to change the column name, however, it
is used to change the table or database name. However the
CHANGE is used to to rename a column with the su=yntax given
above by vipul (Answer 2)

Answer / chandrakant agrawal

ALTER TABLE <owner_name.tab_name> RENAME COLUMN <old_name>
TO <new_name>;


We can also modify the datatype,size of the column using
command alter table

Answer / chaithra.t

ALTER TABLE tablename RENAME COLUMN old_columnname TO
new_columnname;

above is to change the column name of the table.
In case if u want to change the table name then:

ALTER TABLE tablename RENAME TO new_tablename;

How to create table show example

0 Answers  

How do I rename a table in mysql?

0 Answers  

How many primary keys can be there in a table?

0 Answers  

Why do we use mysql?

0 Answers  

What is session variable in mysql?

0 Answers  

Is mysql better than oracle?

0 Answers  

What is mysql routine?

0 Answers  

How we can create index in mysql?

0 Answers  

What, if a table has one column defined as TIMESTAMP?

0 Answers  

How to update database permissions/privilages.

0 Answers  

how we can use more then one primary key in Single Table

9 Answers   Systematix,

What is localhost in mysql?

0 Answers