Wednesday, June 23, 2010

Rename Table's Column Name in Oracle

SQL> desc phone;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PHONE_ID                                  NOT NULL NUMBER(10)
 FK_PHONE_ACCOUNT_ID                       NOT NULL NUMBER(10)
 PHONE_AREACODE                            NOT NULL VARCHAR2(5)
 PHONE_NUMBER                              NOT NULL NUMBER(10)
 PHONE_CITY                                NOT NULL VARCHAR2(40)
 FK_PHONE_PLAN_ID                          NOT NULL NUMBER(5)
 FK_PHONE_USAGE_ID                         NOT NULL NUMBER(5)
 PHONE_ENABLED                             NOT NULL NUMBER(1)
 FK_EMPLOYEEID                             NOT NULL NUMBER(10)
 COMPANY_AMOUNT                                     NUMBER(10,2)


SQL> alter table phone rename column PHONE_CITY to FK_IIL_COMP_LOC_ID;
SQL> Desc Phone;

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PHONE_ID                                  NOT NULL NUMBER(10)
 FK_PHONE_ACCOUNT_ID                       NOT NULL NUMBER(10)
 PHONE_AREACODE                            NOT NULL VARCHAR2(5)
 PHONE_NUMBER                              NOT NULL NUMBER(10)
 FK_IIL_COMP_LOC_ID                        NOT NULL VARCHAR2(40)
 FK_PHONE_PLAN_ID                          NOT NULL NUMBER(5)
 FK_PHONE_USAGE_ID                         NOT NULL NUMBER(5)
 PHONE_ENABLED                             NOT NULL NUMBER(1)
 FK_EMPLOYEEID                             NOT NULL NUMBER(10)
 COMPANY_AMOUNT                                     NUMBER(10,2)

No comments:

Post a Comment