D – RENAME Statement
You can use the RENAME statement to change a table or view name. Databases support it because the table is truly linked to a numeric identifier in the catalog and its name is only an alias.
You RENAME a table or view, like this:
RENAME chronograph TO watch; |
You rename a column with the ALTER statement and MODIFY subclause.
