Table Option and Table Space Properties

The Table Option and Table Space properties can be used to customize the CREATE TABLE SQL syntax for any platform. All of these settings are reflected in the SQL statement only if the Intermediate Table Type property is set to Permanent table. For a description of that property, see Intermediate Table Type.

Customizing a CREATE TABLE statement is only possible for a permanent table. For all other valid Intermediate Table Type options, the SQL does not reflect the values set for these settings. The location of each table setting in the CREATE TABLE statement is provided below.

create /* Table Qualifier */ table 

/*Table Descriptor*//* Table Prefix

*/ZZTIS003RB6MD000 /*Table Option*/ 

	(STORE_NBR NUMBER, 

	 CLEARANCESAL DOUBLE)

/* Table Space */ 

/* Create PostString */

For more information on the Table Qualifier, Table Descriptor, Table Prefix, and Create Post String properties, see the System Administration Guide.

For platforms like Teradata and DB2 UDB 6.x and 7.x, the Primary Index or the Partition Key SQL syntax is placed between the Table Space and Create Post String VLDB setting.

Table Option

The Table Option property defines the string to be placed after the table name in the CREATE TABLE statement.

Table Space

The Table Space property contains the string appended after the CREATE TABLE Statement but before any Primary Index/Partition key definitions.