Visual C++ 6 Unleashed

By MICKEY WILLIAMS and David Bennett

• Table of Contents
  • Copyright
  • About the Authors
  • About the Contributors
  • Acknowledgments
  • Tell Us What You Think!
  • Introduction
  • How to Use This Book
  • What You Need to Use This Book
  • What's New in Visual C++ 6.0
  • Contacting the Main Author
  • Part I: Introduction
  • Chapter 1. The Visual C++ 6.0 Environment
  • Part II: MFC Programming
  • Chapter 2. MFC Class Library Overview
  • Chapter 3. MFC Message Handling Mechanism
  • Chapter 4. The Document View Architecture
  • Chapter 5. Creating and Using Dialog Boxes
  • Chapter 6. Working with Device Contexts and GDI Objects
  • Chapter 7. Creating and Using Property Sheets
  • Chapter 8. Working with the File System
  • Chapter 9. Using Serialization with File and Archive Objects
  • Part III: Internet Programming with MFC
  • Chapter 10. MFC and the Internet Server API (ISAPI)
  • Chapter 11. The WinInet API
  • Chapter 12. MFC HTML Support
  • Part IV: Advanced Programming Topics
  • Chapter 13. Using the Standard C++ Library
  • Chapter 14. Error Detection and Exception Handling Techniques
  • Chapter 15. Debugging and Profiling Strategies
  • Chapter 16. Multithreading
  • Chapter 17. Using Scripting and Other Tools to Automate the Visual C++ IDE
  • Part V: Database Programming
  • Chapter 18. Creating Custom AppWizards
  • Chapter 19. Database Overview
  • Chapter 20. ODBC Programming
    • ODBC Architecture
    • ODBC API Basics
    • Creating ODBC Applications
    • Executing SQL Statements
    • Working with Result Sets
    • Retrieving More Than One Row at a Time
    • Inserting, Updating, and Deleting Rows
    • Asynchronous Operations
    • Transactions
    • Catalog Functions
    • Summary
  • Chapter 21. MFC Database Classes
  • Chapter 22. Using OLE DB
  • Chapter 23. Programming with ADO
  • Part VI: MFC Support for COM and ActiveX
  • Chapter 24. Overview of COM and Active Technologies
  • Chapter 25. Active Documents
  • Chapter 26. Active Containers
  • Chapter 27. Active Servers
  • Chapter 28. ActiveX Controls
  • Part VII: Using the Active Template Library
  • Chapter 29. ATL Architecture
  • Chapter 30. Creating COM Objects Using ATL
  • Chapter 31. Creating ActiveX Controls Using ATL
  • Chapter 32. Using ATL to Create MTS and COM+ Components
  • Part VIII: Finishing Touches
  • Chapter 33. Adding Windows Help
  • Part IX: Appendix

Catalog Functions

In most cases, when you are developing a database application, you should already know about the structure of the database. However, for certain browser-type applications or administrative tools, your app may not know much about the data source until runtime. You can retrieve information about the structure (catalog, schema, and so forth) of a database with the following functions provided by ODBC:

• SQLTables() returns information about the tables in a database.
• SQLColumns() returns the names of the columns in a table.
• SQLSpecialColumns() returns information about the columns that uniquely identify a row, and any columns that are automatically updated when the row is updated (rowids).
• SQLPrimaryKeys() returns the columns that make up a table's primary key.
• SQLForeignKeys() returns the columns in a table that refer to the primary key of another table, as well as the columns in other tables that refer to this column's primary key.
• SQLProcedures() returns a list of procedures available on this data source.
• SQLProcedureColumns() returns information about the parameters for a procedure, as well as info about its result set.
• SQLTablePrivileges() returns information about the privileges associated with tables in the database.
• SQLColumnPrivileges() returns a list of columns and the privileges associated with them for a given table.
• SQLStatistics() returns a set of statistics for a table and its associated indexes.

Share This