List of available tables

The list of available tables is a list of the schemas and tables that are available to be used in the current SQL statement or File Upload statement.

The list of available tables is located:

• On the Tables tab of the SQL Wizard.
  • Java 1 browsers: see Select Table(s).
  • Java 2-enabled browsers: see Available tables.
• On the Table tab of the File Upload Wizard.
  • Java 1 browsers: see Select a reference table, Select a table.
  • Java 2-enabled browsers: see Available tables.

In Java 1 browsers, the list of available tables appears as a listbox of table names:

• Each table name is in the format schema_name.table_name (for example, HODTEST.TEST01),
• A checkbox precedes each table name.

In Java 2-enabled browsers, the list of available tables appears as a tree of schemas and tables.

Related topics:

• Levels of filtering for schema names and table names
• Specifying a list of available schemas and tables
• Table Filter (Administrator, Database On-Demand)
• Table filter
• Java 1 browser:
  • Table Filter (SQL Wizard)
  • Table Filter (File Upload)
  • Selected schema(s) (SQL Wizard, File Upload)
  • Enter the table name filter to use below (SQL Wizard, File Upload)
• Java 2-enabled browser:
  • Table Filter (SQL Wizard)
  • Table Filter (File Upload)
  • Selected schemas (SQL Wizard, File Upload)
  • Enter a table name filter (SQL Wizard, File Upload)