ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-127
SQLTables
SQLTables
SQLTables lists database, schema name, and table information.
Input parameters for SQLTables are:
•
TABLE_QUALIFIER
•
TABLE_OWNER
•
TABLE_NAME
•
TABLE_TYPE
COLLATION CHAR (1) The collating sequence of the keys:
A Ascending
D Descending
CARDINALITY INT (2) Assigned null.
PAGES INT (2) Assigned null.
Table 7-11. Result Set for SQLTables Procedure
Result Column Data Type Description
TABLE_QUALIFIER VARCHAR (60) Assigned null.
TABLE_OWNER VARCHAR (60) The owner of the table.
TABLE_NAME VARCHAR (60) The name of the table.
TABLE_TYPE VARCHAR (60) The type of table:
N or S System view
T Base table
VView
REMARKS VARCHAR (254) Comments.
Table 7-10. Result Set for SQLProcedureColumns Procedure (page 2 of 2)
Result Column Data Type Description