RENAME Statement

Rename a table, view or private synonym.

Syntax:

   RENAME old TO new

To rename table columns:

CREATE TABLE tmp AS SELECT...
DROP TABLE ...
RENAME tmp TO ...

You can also
ALTER TABLE MODIFY COLUMN...
ALTER TABLE DROP COLUMN...
ALTER TABLE SET UNUSED COLUMN...

"A clever man commits no minor blunders." - Goethe (1749-1832)

Related Commands:

TABLE - CREATE TABLE
TABLE - ALTER TABLE
INSERT
SELECT

TRUNCATE

UPDATE

Related Views:

  DBA_SNAPSHOTS        ALL_SNAPSHOTS        USER_SNAPSHOTS 
  DBA_ALL_TABLES       ALL_ALL_TABLES       USER_ALL_TABLES
  DBA_TABLES           ALL_TABLES           USER_TABLES         TAB
  DBA_VIEWS            ALL_VIEWS            USER_VIEWS
                                                                DICTIONARY
                                                                DICT_COLUMNS



Back to the Top

Simon Sheppard
SS64.com