ODBC_SQLTables

Home

4D v16

ODBC_SQLTables


ODBC_SQLTables ( stmtID ; catalogName ; schemaName ; tableName ; tableType ) -> Funktionsergebnis

Parameter	Typ	Beschreibung
stmtID	Lange Ganzzahl	Statement ID
catalogName	String	Catalog name
schemaName	String	String search pattern for schema names
tableName	String	String search pattern for table names
tableType	String	List of table types to match
Funktionsergebnis	Lange Ganzzahl	Returns the result of the MS ODBC API function SQLTables

The ODBC_SQLTables command returns the list of table, catalog, or schema names, and table types, stored in a specific data source.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

catalogName is the catalog name.

schemaName is the string search pattern for schema names.

tableName is the string search pattern for table names.

tableType is the list of table types to match.

For more information, please see the SQLTables function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms711831(VS.85).aspx.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

Siehe auch