Renaming a Table

You rename a table using the RENAME statement. The following example renames emp to new_employee:


SQL> RENAME emp TO new_employee;

Table renamed.

SQL>
Home »
Oracle »
Table » 

Table Creation:
  1. Creating a Table
  2. Getting Information on Tables
  3. Information on Columns in Tables
  4. Renaming a Table
  5. Truncating a Table
  6. Dropping a Table
Related: