The ANSI SQL3 (SQL99) standard does not include the capability to rename a table, but IBM's DB2 database does provide this capability. The syntax is
Rename Table source_table to new_table;
Rename Table Cust to Customer;
The source_name can include the schema name while the target_name does not. This is a simple and quick way to rename a table in the DB2 database. (A previous tip discussed the capability of SQL Server to rename a Table using the sp_rename stored procedure.)