Metadata includes the definition of the database and database objects such as domains, generators, tables, constraints, indices, views, triggers, stored procedures, user-defined functions (UDFs) and blob filters. Metadata is stored in system tables, which are themselves part of every Firebird/InterBase® database.
Metadata includes all those SQL statements necessary to recreate the database object. It comprises the following elements:
- declarative referential integrity using the
- check constraints using
- procedure definitions using
- trigger definitions using
- granting of user authorizations for tables, views and stored procedures.
Metadata for a table includes all domains and generators used by these tables plus the
CREATE TABLE statement. It does not include any referential integrity definitions from this table to other tables or from other tables to this table.
Metadata for a view includes both the
CREATE VIEW and
ALTER VIEW statements.
The current metadata definitions can be viewed on the DDL page in the individual object editors.