Online Documentation for SQL Manager for Oracle

Setting table properties


Use the Table tab of Table Editor to specify new table properties.

 

Name

Specify the name of the table to be created. Note that the table name must be unique within its schema.

 

Schema

Use the drop-down list to specify the schema in which the table will be created.

 

New table - Setting table properties

 

Organization

This group allows you to specify the order in which the data rows of the table are stored:

RadioButton Regular

RadioButton Global temporary

RadioButton Clustered

RadioButton Index-organized

RadioButton External

 

CheckBox Object table

Defines that an object table (which is a table that uses an object type for a column definition) should be created. An object table is explicitly defined to hold object instances of a particular type.

 

Object type owner

Use the drop-down list to select the schema in which the object type is located.

 

Object type name

Use the drop-down list to select the object type that will be used by the object table.

 

The columns of an object table correspond to the top-level attributes of type which is specified in the Object type name field. Each row will contain an object instance, and each instance will be assigned a unique, system-generated object identifier when a row is inserted.

 

The properties below vary according to the selected table organization type. For details see Table Properties.

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.