Example 1: Changing a table name

Nonstop Database, HiRDB Version 9 System Operation Guide

This example changes the name of a table from TABLE01 to TABLE02.

Organization of this subsection: (1) Use the ALTER TABLE statement to change a table's name

 
ALTER TABLE TABLE01 RENAME TABLE TO TABLE02;