table_name – is the name of the table. Use the wildcard character
to request information about more than one table.
table_owner – is the owner of the table. Use the wildcard character
to request information about tables owned by more than one user.
table_qualifier – is ignored for DB2 UDB targets. Leave blank or set to NULL.
For non DB2 targets, is the
name of the database. Acceptable values are the current database or NULL.
table_type – is a list of values, separated by commas, that gives information about the table types
specified.
Usage
Enclose each table type with single quotation marks and
enclose the entire parameter with double quotation marks. Enter table types in uppercase. For
example: “‘TABLE’, ‘SYSTEM TABLE', ‘VIEW’, ‘SYNONYM’”
This procedure corresponds to the ODBC function SQLTables.