How can we change the name of a column of a table?
Answers were Sorted based on User's Feedback
Answer / vipul dalwala
ALTER TABLE table_name change OLD_COLUMN_NAME
NEW_COLUMN_NAME VARCHCHAR(100) NULL;
Is This Answer Correct ? | 18 Yes | 3 No |
Answer / tushar
ALTER TABLE table_name change OLD_COLUMN_NAME
NEW_COLUMN_NAME VARCHAR(255) NULL;
Is This Answer Correct ? | 6 Yes | 0 No |
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.
Is This Answer Correct ? | 3 Yes | 0 No |
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.
Is This Answer Correct ? | 5 Yes | 4 No |
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)
Is This Answer Correct ? | 1 Yes | 0 No |
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
Is This Answer Correct ? | 1 Yes | 6 No |
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;
Is This Answer Correct ? | 1 Yes | 6 No |
How do I run mysql?
What is meant by decimal (5,2)?
How do I show all mysql databases?
What are the advantages and disadvantages of using mysql?
What is pdo connection?
What are the applications required to support mysql?
Explain GRANT command in MySQL.
How do I clear a mysql database?
What is the query to display top 20 rows?
What is mysqlcommand?
How do I install mysql workbench?
how to delete duplicate rows in sql server 2005?