--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@a...>
wrote:

> It is not part of the SQL standard, yet. It has been suggested to

add

> to the standard the statement RENAME TABLE, but it is just a
> suggestion as of now and not part of SQL-2003(only mentioned in 2
> lines of text). Although, MS-SQL doesn't support it, Oracle does.
> So, my guess is that it is Oracle that submitted the RENAME TABLE
> syntax to be included in the standard.

Oracle isn't the only DBMS supporting this:

PostgreSQL, MySQL and Sybase SQL Anywhere support renaming a table as
well. To my knowledge SQL Server does support it as well via the
sp_rename stored procedure.

Regards
Thomas