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
Write a query to stop mysql in unix
what is the default port for mysql server? : Mysql dba
What is ntext?
How do I find my mysql username and password?
What is different between sql and mysql?
Can mysql handle big data?
How do I run mysql without installing?
How to get last inserted id after insert data from a table in mysql?
What is the latest version of mysql?
How to Set a root password if there is on root password.
I want to start and stop mysql on windows? How do I do that?
How do I connect to mysql database?
Can I use mariadb instead of mysql?
How to create a trigger in mysql?
How can I compare two mysql databases?