Rename Column Name IN SQL - sql - sql tutorial - learn sql

1. ALTER TABLE "table _name" Change "column 1" "column 2" ["Data Type"];
   

2. ALTER TABLE "table _name" RENAME COLUMN "column 1" TO "column 2";
   

3. ALTER TABLE Customer CHANGE Address Addr char(50);
   

4. ALTER TABLE Customer RENAME COLUMN Address TO Addr ;
   

• Sometimes we want to change the name of a column.
• To do this in SQL, we specify that we want to change the structure of the table using the ALTER TABLE command, followed by a command that tells the relational database that we want to rename the column.
• The exact syntax for each database is as follows:
• In MySQL, the SQL syntax for ALTER TABLE Rename Column is,

ALTER TABLE "table_name"
Change "column 1" "column 2" ["Data Type"];

• In Oracle, the syntax is,

ALTER TABLE "table_name"
RENAME COLUMN "column 1" TO "column 2";

• Let's look at the example. Assuming our starting point is the wikitechy Customer table created in the CREATE TABLE section:

Table wikitechy Customer

• To rename "Address" to "Addr", we key in,

Tags : sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorial

MySQL:

ALTER TABLE wikitechy Customer CHANGE Address Addr char(50);

Oracle:

ALTER TABLE wikitechy Customer RENAME COLUMN Address TO Addr;

sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorial

SQL Server:

• It is not possible to rename a column using the ALTER TABLE statement in SQL Server. Use sp _rename instead.

This tutorial provides more the basic needs and informations on sql tutorial , pl sql tutorial , mysql tutorial , sql server , sqlcode , sql queries , sql , sql formatter , sql join , w3schools sql , oracle tutorial , mysql , pl sql , learn sql , sql tutorial for beginners , sql server tutorial , sql query tutorial , oracle sql tutorial , t sql tutorial , ms sql tutorial , database tutorial , sql tutorial point , oracle pl sql tutorial , oracle database tutorial , oracle tutorial for beginners , ms sql server tutorial , sql tutorial pdf