standard.db.sql.ODBCListColumns

ODBCListColumns is available since version 1.0.

Prototype:

number ODBCListColumns(string catalog, string schema, string name, string column[, number connectionID])

Parameters

catalog
Catalog name. The CatalogName argument accepts search patterns if the SQL_ODBC_VERSION environment attribute is SQL_OV_ODBC3; it does not accept search patterns if SQL_OV_ODBC2 is set. If a driver supports catalogs for some tables but not for others, such as when a driver retrieves data from different DBMSs, an empty string ("") denotes those tables that do not have catalogs.
schema
String search pattern for schema names. If a driver supports schemas for some tables but not for others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes those tables that do not have schemas.
name
String search pattern for table names.
column
String search pattern for column names.
connectionID
the ID identifying the connection as returned by ODBCDriverConnect or ODBCConnect. If this parameter is missing, this will affect the first connection created.

Description:

Get the list of column names in specified tables. The result is stored as a result set.

Return value:

Return a result set handle, or null if failed.