4D v13

ODBC_SQLTables

Home

 
4D v13
ODBC_SQLTables

ODBC_SQLTables 


 

ODBC_SQLTables ( stmtID ; catalogName ; schemaName ; tableName ; tableType ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
catalogName  String in Catalog name
schemaName  String in String search pattern for schema names
tableName  String in String search pattern for table names
tableType  String in List of table types to match
Function result  Longint in 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.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Catalog functions
Number: 16937

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLTablePrivileges