TZSqlMetadata

TZSqlMetadata

TZSqlMetadata is a TDataset descandant that can be used to retrieve metadata information from the database, such as a list of tables or fields in a table or.... The type of Metadata to retrieve is set by the property MetadataType.

mdTables - list of tables

When fetching tables, a dataset with the following colulmns will be created:

Column	Description
TABLE_CAT	The catalog or database that the table belongs to.
TABLE_SCHEM	The schema that the table belongs to.
TABLE_NAME	The name of the table.
TABLE_TYPE	The type of the table. Table types differ between databases.
REMARKS	Remarks regarding the table.

Firebird / Interbase Notes

The Firebird / Interbase drivers will return the following table types: TABLE, VIEW, SYSTEM TABLE.