如何修改表字段的名字

郑全

如下表,希望修改first_name字段名字为fname:

 

SQL> desc dept80
Name Null? Type
----------------------------------------- -------- --------------
EMPLOYEE_ID NUMBER(6)
LAST_NAME NOT NULL VARCHAR2(10)
ANNSAL NUMBER
HIRE_DATE NOT NULL DATE
JOB_ID VARCHAR2(9)
FIRST_NAME DATE

 

 

sql> alter table dept80 rename column first_name to fname;

 

成功后:

SQL> desc dept80;
Name Null? Type
----------------------------------------- -------- --------------------
EMPLOYEE_ID NUMBER(6)
LAST_NAME NOT NULL VARCHAR2(10)
ANNSAL NUMBER
HIRE_DATE NOT NULL DATE
JOB_ID VARCHAR2(9)
FNAME DATE

[此贴子已经被作者于2012-8-18 17:54:32编辑过]