SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-91
Considerations for CREATE TABLE
Partitions
If there is a possibility that you might need to partition a table in the future, you should
create it with at least one partition. This avoids recompilation if you add more partitions
later.
The LIKE specification
The CREATE TABLE LIKE statement does not create views, owner information, or
privileges for the new table based on the source table. Privileges associated with a
new table created by using the LIKE specification are defined as if the new table is
created explicitly by the current user.
The existing behavior of CREATE TABLE LIKE is retained. CREATE TABLE LIKE does
not create the RI constraint for the target table.
If the source table has any unique or droppable primary key constraints, NonStop
SQL/MX creates indexes for them on the target table. Other indexes on the source
table are not created on the target table.
The LIKE specification ignores triggers.