Displaying Database Names and Structures

If you do not know the names of the tables, columns, and keys in your database, you will not be able to construct queries. Fortunately, CA Dataquery makes it easy for you to get that information. Every panel where you might need that information has a PF key assignment for tables, columns, and keys. For details about the operation of the panels in this manual, see the CA Dataquery Reference Guide.

The following few pages show examples of panels that display:

A list of accessible tables
The text description of a table
The names of columns in a table
The names of keys for a table
The names of both keys and columns in a table
The definitions of the columns or keys for a table