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 truncate all tables in mysql?
How database are managed?
What is text in mysql?
How do I save in mysql?
How do I stop a mysql command?
What is the current mysql version?
How to escape special characters in sql statements?
What is mysql data directory?
When to use order by in delete statement?
Which statement is used in a select query for partial matching?
How to include comments in sql statements?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products