blocks|key|199318|text|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|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|199319|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SQL&gt; create table a(id number);

Table created.

SQL&gt; alter table a rename column id to new_id;

Table altered.

SQL&gt; desc a
 Name Null? Type
 ----------------------------------------- -------- -----------
 NEW_ID NUMBER
</code></pre>

blocks|key|199334|text|alter+table+table_name+rename+column+oldColumn+to+newColumn;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|199335|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>alter table table_name rename column oldColumn to newColumn;
</code></pre>

blocks|key|199346|text|假设supply_master是一个表，并且|type|unstyled|depth|inlineStyleRanges|entityRanges|data|199347|SQL>desc+supply_master;


SQL>Name
+SUPPLIER_NO++++
+SUPPLIER_NAME
+ADDRESS1+++++++
+ADDRESS2+++++++
+CITY+++++++++++
+STATE++++++++++
+PINCODE++


SQL>alter+table+Supply_master+rename+column+ADDRESS1+TO+ADDR;
Table+altered



SQL>+desc+Supply_master;
+Name+++++++++++++++++++
+-----------------------
+SUPPLIER_NO++++++++++++
+SUPPLIER_NAME++++++++++
+ADDR+++///////////this+has+been+renamed........//////////////++++++++++++++++
+ADDRESS2+++++++++++++++
+CITY+++++++++++++++++++
+STATE++++++++++++++++++
+PINCODE++++++++++++++++++|code-block|syntax|javascript|199348|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

suppose supply_master is a table, and 

<pre><code>SQL&gt;desc supply_master;


SQL&gt;Name
 SUPPLIER_NO 
 SUPPLIER_NAME
 ADDRESS1 
 ADDRESS2 
 CITY 
 STATE 
 PINCODE 


SQL&gt;alter table Supply_master rename column ADDRESS1 TO ADDR;
Table altered



SQL&gt; desc Supply_master;
 Name 
 -----------------------
 SUPPLIER_NO 
 SUPPLIER_NAME 
 ADDR ///////////this has been renamed........////////////// 
 ADDRESS2 
 CITY 
 STATE 
 PINCODE 
</code></pre>

blocks|key|417539|text|查询的语法如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|417540|Alter+table+<table+name>+rename+column+<column+name>+to+<new+column+name>;|code-block|syntax|javascript|417541|示例：|417542|Alter+table+employee+rename+column+eName+to+empName;|417543|要将不带空格的列名重命名为带空格的列名：|417544|Alter+table+employee+rename+column+empName+to+"Emp+Name";|417545|要将带空格的列重命名为不带空格的列名：|417546|Alter+table+employee+rename+column+"emp+name"+to+empName;|417547|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

The syntax of the query is as follows:

<pre><code>Alter table &lt;table name&gt; rename column &lt;column name&gt; to &lt;new column name&gt;;
</code></pre>

Example:

<pre><code>Alter table employee rename column eName to empName;
</code></pre>

To rename a column name without space to a column name with space:

<pre><code>Alter table employee rename column empName to "Emp Name";
</code></pre>

To rename a column with space to a column name without space:

<pre><code>Alter table employee rename column "emp name" to empName;
</code></pre>

blocks|key|199390|text|alter+table+table_name+
rename+column+old_column_name/field_name+to+new_column_name/field_name;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|199391|示例：alter+table+student+rename+column+name+to+username;|unstyled|offset|length|style|CODE|199392|entityMap^0|0|3|1F|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>alter table table_name 
rename column old_column_name/field_name to new_column_name/field_name;
</code></pre>
example: <code>alter table student rename column name to username;</code>

I would like to know:
How to rename a table column in Oracle 10g?

How to rename a table column in Oracle 10g

我想知道:在Oracle10g中如何重命名表列？

问如何在Oracle 10g中重命名表列
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Oracle 10g中重命名表列EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Oracle 10g中重命名表列
EN