我想知道:在Oracle10g中如何重命名表列?
发布于 2012-12-14 20:09:12
SQL> create table a(id number);
Table created.
SQL> alter table a rename column id to new_id;
Table altered.
SQL> desc a
Name Null? Type
----------------------------------------- -------- -----------
NEW_ID NUMBER
发布于 2013-08-29 16:06:51
查询的语法如下:
Alter table <table name> rename column <column name> to <new column name>;
示例:
Alter table employee rename column eName to empName;
要将不带空格的列名重命名为带空格的列名:
Alter table employee rename column empName to "Emp Name";
要将带空格的列重命名为不带空格的列名:
Alter table employee rename column "emp name" to empName;
发布于 2012-12-14 20:10:44
alter table table_name rename column oldColumn to newColumn;
https://stackoverflow.com/questions/13878383
复制相似问题