Active Query Builder  »  SQL Query Builder

Metadata Handling and Filtration

Various ways to load and represent metadata in Active Query Builder

• Metadata pre-filtering

  When building a query, it's not necessary to load all metadata at once. Active Query Builder allows you to filter database objects by the database and schema name, object name mask, and object type (table, view, synonym, procedure and function). Partial metadata loading speeds up the metadata loading process for large database schemas.

  If a database server lets you use objects from different databases in a single query, Active Query Builder can be instructed to load metadata from several databases at once.

• Working while disconnected from a database, loading metadata programmatically, storing metadata in XML files.

  Active Query Builder can work with any database access library, OLE DB, or ODBC data provider. But when a direct connection to a database is undesirable or even impossible for reasons of security or performance, for example in a multi-tier environment, the most convenient solution is to load metadata from a pre-generated XML file or fill the Metadata Container programmatically.

  Code samples illustrating various ways of metadata loading can be found in the Load Metadata demo project included in the installation package.

• Quick Start Guides
• Loading metadata from XML file
• Database server autodetection
• SQL query validation

• Simple and clear visual SQL query building interface
• Customizable SQL query building environment
• Programmatic SQL Query analysis and modification