| Syntax 
   define external counter function SQLTables
     (  read-only SQL_handle_type StatementHandle,
        value stream CatalogName,
        value counter NameLength1,
        value stream SchemaName,
        value counter NameLength2,
        value stream TableName,
        value counter NameLength3,
        value stream TableType,
        value counter NameLength4 )
 Purpose
 
 Returns the list of table, catalog, or schema names stored in a specific data source. The information is returned as a result set. 
 Input arguments:
 StatementHandle.
CatalogName. A search pattern is allowed if the SQL_ODBC_VERSION environment attribute is SQL_OV_ODBC3, but not if it is set to SQL_OV_ODBC2. If a driver supports catalogs for some tables but not others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes tables without catalogs.
NameLength1. The length of CatalogName.
SchemaName. A string-search pattern for schema names. If a driver supports schemas for some tables but not others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes tables without schemas.
NameLength2. The length of SchemaName.
TableName. A string-search pattern for table names.
NameLength3. The length of TableName.
TableType. The list of table types to match.
NameLength4. The length of TableType.
 |