Obtaining information about the data source’s system tables
These data dictionary or catalog functions return information about how data is stored in the database:
-
SQLColumnPrivileges
odbc SQLColumnPrivileges $hstmt NULL 0 NULL 0 \ NAMEID SQL_NTS NULL 0
-
SQLColumns
odbc SQLColumns $hstmt NULL 0 NULL 0 NAMEID \ SQL_NTS NULL 0
-
SQLForeignKeys
odbc SQLForeignKeys $hstmt NULL 0 NULL 0 NAMEID \ SQL_NTS NULL 0 NULL 0 NULL 0
-
SQLPrimaryKeys
odbc SQLPrimaryKeys $hstmt NULL 0 NULL 0 NAMEID \ SQL_NTS
-
SQLProcedureColumns
odbc SQLProcedureColumns $hstmt NULL 0 NULL 0 \ NULL 0 NULL 0
-
SQLProcedures
odbc SQLProcedures $hstmt NULL 0 NULL 0 NULL 0
-
SQLSpecialColumns
odbc SQLSpecialColumns $hstmt SQL_ROWVER NULL 0 \ NULL 0 sysalternates SQL_NTS SQL_SCOPE_SESSION \ SQL_NULLABLE
-
SQLStatistics
odbc SQLStatistics $hstmt NULL 0 NULL 0 NAMEID \ SQL_NTS SQL_INDEX_ALL SQL_ENSURE
-
SQLTablePrivileges
odbc SQLTablePrivileges $hstmt NULL 0 NULL 0 NULL 0
-
SQLTables
odbc SQLTables $hstmt NULL 0 NULL 0 "Orders" \ SQL_NTS NULL 0