Renombrar Tabla de la BD

[trasgukabi]

Rename column(s) in a table
(NEW in Oracle 9i Release 2)(nada de access, ni nada de nada, excepto...)

Syntax #1

Starting in Oracle 9i Release 2, you can now rename a column.

To rename a column in an existing table, the ALTER TABLE syntax is:

ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

For example:

ALTER TABLE supplier
RENAME COLUMN supplier_name to sname;

This will rename the column called supplier_name to sname.