Modify column metadata in a table

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.

  1. Navigate to the Columns tab.
  2. In the Column name drop-down list, select the column you wish to modify.
  3. 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.
  4. In the Underlying column drop-down list, select a different 1010data column, if desired.
  5. In the MDB type drop-down list, select a different MDB type, if desired.
  6. In the SQL type drop-down list, select a different SQL type, if desired.
  7. In the Cardinality field, modify the number of unique column entries, if desired.
  8. 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.

  9. Click Save changes to this column to save the column metadata.