Creating metadata queries

This procedure explains how to create queries that you can use to retrieve metadata from applications and from IOS.

You can create these types of metadata queries:

Type	Description
DataAreas	Retrieves a list of available data areas.
Tables	Retrieves information on the OLE DB table schema rowsets for all files in a data area, all files in a system code, or an individual file.
Columns	Retrieves information on OLE DB column schema rowsets for all files in a data area, all files in a system code, or an individual files
ProviderTypes	Retrieves information about the OLE DB provider types.
SystemCodes	Retrieves information about the available system codes. You can query for all system codes, all system codes within a data area, or an individual system code.
TableInfo	Retrieves information about a table (file) and its columns (fields). You can query for all tables, all tables within a system code, or an individual table.
AGSfield	Returns form field metadata for all forms in the system, all forms within a data area, all forms within a system code, or an individual form.
AGSform	Returns form metadata for all forms in the system, all forms within a data area, all forms within a system code, or an individual form.
AGSSchema	Returns ADO schema metadata.
AGSString	Returns the default query strings for form queries. You can retrieve the query string for all forms within a data area, all forms within a system code, or an individual form.
AGSToken	Retrieves the form ID and title for forms. You can retrieve the form information all forms within a data area, all forms within a system code, or an individual form.
DrillBook	Returns a list of Drill Around queries for all forms in a data area, all forms in a system code, or an individual form.
AttachmentInfo	Returns attachment information.
ReportInfo	Returns report metadata for an indivdidual report.

To create a metadata query