skip to main content
Part 4: The Connect XE Drivers : The Driver for the Teradata Database : Connection Option Descriptions : Show Selectable Tables
  
Show Selectable Tables
Attribute
ShowSelectableTables (SST)
Purpose
Determines whether the driver supports X views.
Valid Values
Yes | No
Behavior
If set to Yes (Enabled), SQLTables() and SQLProcedures() use dbc.tablesX and dbc.databasesX instead of dbc.tables and dbc.databases. Also, SQLColumns() and SQLProcedureColumns() use dbc.columnsX instead of dbc.columns. SqlStatistics() uses dbc.tablesizeX instead of dbc.tablesize. The X tables only contain information that the user has permission to access. These tables are optional for Teradata, so verify that they exist.
If set to No (Disabled), SQLTables() and SQLProcedures() use dbc.tables and dbc.databases. Also, SQLColumns() and SQLProcedureColumns() use dbc.columns. SqlStatistics() uses dbc.tablesize.
Default
Yes (Enabled)
GUI Tab
Options tab