Columns

The Columns tab of the SQL Metadata Tool allows you to create and modify column metadata for the table.

Current schema: The schema containing the column, which is selected in the Schemas tab.
Current table: The table containing the column, which is selected in the Tables tab.
Underlying 1010data table: The underlying 1010data table used to create the SQL table, which is selected in the Tables tab.
Column name: The name of the column. Select an existing column from the drop-down list, or enter a new column name and click New.

The following options are available once you select a table.

Rename it to: The new name for your column, if you choose to rename it.
Underlying column: Enter the underlying 1010data column name for the SQL column, or leave the default name.
MDB type: The MDB type of the column. Select an MDB type from the drop-down list, or leave the default MDB type.
Get column list: Click to get a column drop-down list for the underlying column. You can then click Analyze column for the SQL Metadata Tool to choose the most appropriate SQL metadata for the column.
SQL type: The SQL type of the column. Select an SQL type from the drop-down list, or leave the default SQL type.
Cardinality: This is the number of unique values in the column . You can edit this number or leave the default value.
Unique: Selected if each value in the column is unique (unique attribute in the SQL metadata).
Sorted: Selected if each value in the column is sorted (sorted attribute in the SQL metadata).
Indexed: Selected if there is an index in the column (indexed attribute in the SQL metadata).
Nullable: Selected if nulls are permitted in the column (null attribute in the SQL metadata).
Case-insensitive: Selected if the column should be treated as case-insensitive in certain SQL expressions (case attribute in the SQL metadata).
Save changes to this column: This button appears when you have made changes to the column. Click to save your changes.
Abandon changes: This button appears when you have made changes to the column. Click to abandon your changes.
Drop this column: Click to delete the selected column. You must have drop_schema or drop_self_schema (if it is a personal schema) privileges.