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