| Syntax 
   define external counter function SQLColumns
     (  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 ColumnName,
        value counter NameLength4 )
 Purpose
 
 Returns the list of column names in specified tables. The information is returned as a result set on the specified statement handle.
 Input arguments:
 StatementHandle.
CatalogName.The catalog name. 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. CatalogName cannot contain a string search pattern.
NameLength1. The length of CatalogName.
SchemaName. The 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. The string-search pattern for table names.
NameLength3. The length of TableName.
ColumnName. The string-search pattern for column names.
NameLength4. The length of ColumnName.
 |