#

The number of each column (this value cannot be modified). 

Length 

The length for each column in the virtual database. 

Any integer greater than 0. This value must be appropriate for the data type. 

Name 

The name of each column. 

An unlimited number of characters. 

Datatype 

The type of data stored in each field. 

varchar 

time 

numeric 

timestamp 

Scale 

The number of digits to the right of the decimal point in a number field; for example, 9876.543 has a scale of 3. 

An integer greater than 0. 

Null 

An indicator of whether the field can be null. 

Select the check box if the field can be null or deselect it if the field cannot be null. 

PK 

An indicator of whether the column is a primary key. 

Select the check box if the column is a primary key or deselect it if the column is not a primary key. 

Default 

Any default data to add to a column.