Show Virtual 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 Virtual Schemas
Attribute
ShowVirtualSchemas
Purpose
Returns "XML" in the Schema Name column when a SQLTables or SQLColumns operation is performed when connected to a data source. For example:
| Schema Name | Table Name |
|---|---|
| XML | TAB1A |
| XML | TAB1B |
| XML | TAB2A |
| XML | TAB2B |
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), virtual schema names are returned.
If set to 0 (Disabled), virtual schema names are not returned.
To return both virtual and manufactured schema names, set this option to 1 (Enabled) and the Show Manufactured Schemas option to 1 (Enabled).
Default
1 (Enabled)