Navigation:  Programming Cookbook > Database Connectivity > Querying the Capabilities of a Data Source >

Querying the Database Structure

Previous pageReturn to chapter overviewNext page

You can also use the DBConnection to easily ask questions about the structure (or catalogue) of the underlying database. Let's find out what tables are available in the NorthWind traders sample database.

c tables. "Display it"

 

You should receive back a collection of table names describing the tables within the database. Hopefully, for the NorthWind sample, this will be confirmed by the database structure as viewed in Microsoft Access (if you have it available).

To find out the descriptions of the columns that exist in a particular table you can use:

c columns: 'Orders'. 'Inspect it'

 

You can compare this with the design view of the Orders table in Access: