Show Manufactured Schemas
- Last Updated: October 3, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
Show Manufactured Schemas
Attribute
ShowManufacturedSchemas
Purpose
Returns the manufactured schema names in the Schema Name column when a SQLTables or SQLColumns operation is performed when connected to a data source. The Location names you define for a data source are manufactured into a schema name by adding a # symbol after the Location names. For example:
| Schema Name | Table Name |
|---|---|
| LOC1# | TAB1A |
| LOC1# | TAB1B |
| LOC2# | TAB2A |
| LOC2# | TAB2B |
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), manufactured schema names are returned.
If set to 0 (Disabled), manufactured schema names are not returned.
To return both manufactured and virtual schema names, set this option to 1 (Enabled) and the Show Virtual Schemas option to 1 (Enabled).
Default
0 (Disabled)