You can modify column metadata after the SQL Metadata Tool analyzes the
table.
You must have a schema and a table selected before you modify column metadata.
If you used auto-populate to create tables or added tables and columns manually, the
SQL Metadata Tool analyzes the tables and assigns SQL metadata. However, you may
override the default column metadata.
-
Navigate to the Columns tab.
-
In the Column name drop-down list, select the column you
wish to modify.
-
Rename the column, if desired.
SQL column names are not subject to the same constraints as 1010data column
names. For example, SQL column names may contain spaces and special
characters.
-
In the Underlying column drop-down list, select a
different 1010data column, if desired.
-
In the MDB type drop-down list, select a different MDB
type, if desired.
-
In the SQL type drop-down list, select a different SQL
type, if desired.
-
In the Cardinality field, modify the number of unique
column entries, if desired.
-
Select one or more of the following flags for your table:
Unique, Sorted,
Indexed, Nullable, or
Case-insensitive.
The SQL Metadata Tool sets these flags when it analyzes the column data, but
you can override the default settings.
See Columns for
more details.
-
Click Save changes to this column to save the column
metadata.