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.

Current schema

The schema that is to contain one or more of the auto-populated tables. Select this schema in the Schemas tab.

Table path

Select one or more underlying paths to tables/Quick Queries from the drop-down list. The drop-down list has the same structure as the Object Manager. You can also enter the path name directly into the field.

Add to list

Click Add to list to add the table path to the path list.

Path list

The complete list of underlying 1010data tables from which to populate the SQL schema.

Analyze and populate schema

Analyzes the underlying 1010data table(s) and auto-populates the current schema with the tables.

Note: If tables with the same name(s) already exist in the schema, they will be replaced.

Clear cache between tables

Select this option to clear the MDB cache after each table is processed.

Usually clearing the cache isn't necessary. However, if you are auto-populating a schema with a long list of tables, and/or have tables with billions of rows, you may run out of workspace memory. Clearing the cache between tables prevents a memory error, but increases the time needed to auto-populate the tables.

SQL table name

You can derive the SQL table name from several options.

is derived from 1010 table name: The underlying table path pub.demo.retail.item becomes the SQL table named item.
is full 1010 pathname (req. quoting): The underlying table path pub.demo.retail.item becomes the SQL table named pub.demo.retail.item.
Note: You must quote the resulting table name in SQL queries because the period (.) character has its own meaning in SQL.
is full pathname replacing . with _: The underlying table path pub.demo.retail.item becomes the SQL table named pub_demo_retail_item. This SQL name does not need to be quoted in SQL queries.
is derived from 1010 table title: The underlying table path pub.demo.retail.item becomes the SQL table named Sales Item Detail (the 1010data table name).