Tables
The Tables tab of the SQL Metadata Tool allows you to create and modify tables for your schema.
- Current schema
- The schema containing the table, which is selected in the Schemas tab. If there is no current schema, you will be asked to select one.
- Table name
- The SQL name of the table (not the underlying 1010data pathname) in the schema. Select an existing table from the drop-down list, or enter a new table name and click New.
The following options are available once you select a table.
- Rename to
- This specifies the new name for your table, if you choose to rename it.
- Underlying path
- Select the underlying 1010data table for the SQL table from the drop-down
list. The drop-down list has the same structure as the Object
Manager.Note: An underlying 1010data "table" can also refer to a Quick Query. You can load a Quick Query into the SQL Metadata Tool much like you would a table. The Quick Query object is then treated as a SQL table, not a view. See Quick Queries/PQQs for more information on creating a Quick Query.
- Refresh
- Click to refresh the table with the latest data from the underlying path.
- Analyze table
- This button appears when you first add an underlying path to your SQL table. Click for the SQL Metadata Tool to analyze the underlying table and apply SQL metadata to the columns. Analyze table also scans each column's data to determine whether it contains any null (NA) values and whether the data is sorted. It also counts the number of unique values (cardinality) .
- Depth (# rows)
- The number of rows of the table, taken from the underlying 1010data table. You can modify this field if desired.
- Save changes to this table
- This button appears when you have made changes to your table. Click to save your changes.
- Abandon changes
- This button appears when you have made changes to your table. Click to abandon your changes.
- Drop this table
- Click to delete the selected table. You must have
drop_schemaordrop_self_schema(if it is a personal schema) privileges.