Home
SQL Metadata Tool
The SQL Metadata Tool allows authorized users to add, edit, and remove SQL schemas, tables, and columns. (Available as of version 17.29)
Modify column metadata in a table
You can modify column metadata after the SQL Metadata Tool analyzes the table.

SQL Metadata Tool
The SQL Metadata Tool allows authorized users to add, edit, and remove SQL schemas, tables, and columns. (Available as of version 17.29)
- Schemas
  The Schemas tab of the SQL Metadata Tool allows you to create and modify a schema or a self-schema.
- Auto-populate
  The Auto-populate tab of the SQL Metadata Tool allows you to autopopulate a SQL schema with one or more SQL tables and add the pathnames of the underlying 1010data tables.
- Tables
  The Tables tab of the SQL Metadata Tool allows you to create and modify tables for your schema.
- Columns
  The Columns tab of the SQL Metadata Tool allows you to create and modify column metadata for the table.
- Order
  The Order tab of the SQL Metadata Tool allows you to modify the order of the current SQL table.
- Keys
  The Keys tab of the SQL Metadata Tool allows you to add one or more columns as keys to the SQL table.
- Foreign
  The Foreign tab of the SQL Metadata Tool allows you to add one or more columns of a foreign table as a foreign key to the SQL table.
- Views
  The Views tab of the SQL Metadata Tool allows you to create and modify views for your schema.
- Settings
  The Settings tab of the SQL Metadata Tool allows you to determine how you want the SQL Metadata Tool to analyze and import 1010data tables and columns.
- Create a schema
  Create an empty SQL schema or self-schema in which to add tables.
- Edit a schema
  Edit a SQL schema or self-schema.
- Auto-populate a schema
  The SQL Metadata Tool allows you to auto-populate a schema with one or more underlying 1010data tables or Quick Queries.
- Add a table to a schema
  Add a table to a specified schema.
- Add a Quick Query to a schema
  Add a 1010data Quick Query to a specified schema.
- Add columns to a table
- Modify column metadata in a table
  You can modify column metadata after the SQL Metadata Tool analyzes the table.
- Create a view
  Create a view in a schema or self-schema.

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.

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.