alter table rename talblename、columnname、indexname、constraintsname

重命名表名、字段名、索引名、约束名

SQL> CREATE TABLE test1 (
2    col1  NUMBER(10) NOT NULL,
3    col2  VARCHAR2(50) NOT NULL);

Table created.

SQL> ALTER TABLE test1 ADD (
2    CONSTRAINT test1_pk PRIMARY KEY (col1));

Table altered.

SQL> DESC test1
Name                 Null?    Type
——————– ——– ——————–
COL1                 NOT NULL NUMBER(10)
COL2                 NOT NULL VARCHAR2(50)

SQL> SELECT constraint_name
2  FROM   user_constraints
3  WHERE  table_name      = ‘TEST1’
4  AND    constraint_type = ‘P’;

CONSTRAINT_NAME
——————————
TEST1_PK

1 row selected.

SQL> SELECT index_name, column_name
2  FROM   user_ind_columns
3  WHERE  table_name = ‘TEST1’;

INDEX_NAME            COLUMN_NAME
——————–  ——————–
TEST1_PK              COL1

1 row selected.

SQL> — Rename the table, columns, primary key
SQL> — and supporting index.
SQL> ALTER TABLE test1 RENAME TO test;

Table altered.

SQL> ALTER TABLE test RENAME COLUMN col1 TO id;

Table altered.

SQL> ALTER TABLE test RENAME COLUMN col2 TO description;

Table altered.

SQL> ALTER TABLE test RENAME CONSTRAINT test1_pk TO test_pk;

Table altered.

SQL> ALTER INDEX test1_pk RENAME TO test_pk;

Index altered.

SQL> DESC test
Name                 Null?    Type
——————– ——– ——————–
ID                   NOT NULL NUMBER(10)
DESCRIPTION          NOT NULL VARCHAR2(50)