Table Types for Dynamic Server

Home | Previous Page | Next Page Disk, Memory, and Process Management > Data Storage >

Table Types for Dynamic Server

You can create logging or nonlogging tables in a logging database on Dynamic Server. The two table types are STANDARD (logging tables) and RAW (nonlogging tables). The default standard table is like a table created in earlier versions without a special keyword specified. You can create either a STANDARD or RAW table and change tables from one type to another.

In a nonlogging database, both STANDARD tables and RAW tables are nonlogging. In a nonlogging database, the only difference between STANDARD and RAW tables is that RAW tables do not allow indexes and referential constraints.

Table 31 lists the properties of the types of tables available with Dynamic Server. The flag values are the hexadecimal values for each table type in the flags column of systables.

Table 31. Table Types for Dynamic Server
Characteristic	STANDARD	RAW	TEMP
Permanent	Yes	Yes	No
Logged	Yes	No	Yes
Indexes	Yes	No	Yes
Rollback	Yes	No	Yes
Recoverable	Yes	Yes, if not updated	No
Restorable	Yes	Yes, if not updated	No
Loadable	Yes	Yes	Yes
Enterprise Replication	Yes	No	No
Flag Value	None	0x10	None