SQLTables

This function returns a list of table names and associated information stored in the system catalogs of the connected data source.

Syntax :

RETCODE SQLTables(hstmt, catalogName, lenCatalogName, schemaName, lenSchemaName, tableName, lenTableName, tableType, lenTableType);

Arguments :

The arguments for SQLTables are listed in below table.

Type	Name	Description
SQLHSTMT	hstmt	Statement handle
SQLCHAR*	catalogName	Buffer that might contain a pattern-value to qualify the result set. Catalog is the first part of a three-part table name. This must be a NULL pointer or a zero length string.
SQLSMALLINT	lenCatalogName	Length of catalogName. This must be set to 0.
SQLCHAR*	schemaName	Buffer that might contain a pattern-value to qualify the result set by schema name.
SQLSMALLINT	lenSchemaName	Length of SchemaName
SQLCHAR*	tableName	Buffer that might contain a pattern-value to qualify the result set by table name.
SQLSMALLINT	LenTableName	Length of tableName
SQLCHAR*	tableType	Buffer that might contain a value list to qualify the result set by table type.
SQLSMALLINT	lenTableType	Size of tableType

Page last modified on September 26, 2009, at 01:53 AM