skip to main content
OpenAccess SDK Service Attributes : Defining Service Attributes : DataSourceSchemaFilterList
 

DataSourceSchemaFilterList

A schema name filter for SQLTables and SQLProcedures (ODBC), getTables and getProcedures (JDBC), and TABLES and PROCEDURES (OLE DB/ADO).

Valid values

Any defined schemas including:
*list_of_schema_names=A comma-separated list of schemas. Only tables owned by the listed schemas are included in the result set. You can use the % or _ character as a search pattern. You cannot use quotes.
*CURRENT SCHEMA=Only tables owned by the current user are returned.

Default

An empty string

Type

Dynamic