Defining Miscellaneous Information

When you create database tables or change table definitions, you can make the following additional entries in the Misc field:

Specification

Description

Comment

Notes

Duplicates

You can use the DUPLICATES clause to control behavior if key collisions occur.

Statistics

Sample Value specifies how large the portion of data is that is included for optimization of the database strategy.

Temporary Table

Ignore Rollback

The table is a temporary table and is saved locally under Temp. For temporary tables, you can specify the option Ignore Rollback.

Identifiers Uppercase

Automatic conversion of table names, column headers and other names into upper case.

A change to this setting affects the entire table definition immediately.

If you use a database table as a template for the creation of another database table, the user setting is copied from the template.

For information on the syntax of CREATE TABLE statements, see the CREATE TABLE Statement section of the SQL Reference Manual.