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