SQLColumns

This function returns a list of columns in the specified tables with their attributes.

Syntax :

RETCODE SQLColumns (hstmt, catalogName, lenCatalogName, schemaName, lenschemaname, tableName, lenTableName, columnName, lencolumnName);

Arguments :

The arguments for SQLColumns 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*	columnName	Buffer that might contain a pattern-value to qualify the result set by column name.
SQLSMALLINT	lencolumnName	Length of columnName

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