Full Feature List: Active Query Builder ASP.NET Edition

• Complete visual building of complex SQL queries
  • Visual building of unions, sub-queries, derived tables and CTE
  • Design Pane to visualize joins between tables in the query
  • Query Columns Grid to define resulting query columns as well as criteria, grouping and sorting
  • Query Structure Tree to browse and navigate the structure of complex queries quickly
  • Database Schema Tree to add objects and fields to the query
  • Datasource, Link and Query Properties dialogs to define various query options visually
  • Customizable datasource field lists with ability to display data type and description
• Powerful means to ease the visual query building process
  • Joining tables automatically according to foreign keys and programmatically
  • Adding intermediate tables automatically on adding a new table to the query to have the existing tables joined with the new one
  • Combining visual query building with direct SQL text editing
  • Editing of sub-queries independently from the main query
  • Formatting SQL query text layout
• Wide possibilities to customize the query building environment
  • Altering metadata information: relationships between tables, descriptions of objects and fields
  • Hiding unwanted database objects and fields
  • Substituting real database object and field names with user-friendly aliases ("Alternate names")
  • Adding high-usage sub-queries to the list of database objects ("Virtual objects")
  • Adding complex expressions and sub-queries to the list of object fields ("Virtual fields")
• Rich programming interface
  • Getting access to internal query representation objects for programmatic SQL query analysis and modification
  • Retrieving the list of parameters found in the query and useful information about them: data type, related field, operator
  • Pre-filtering of database objects to speed up metadata loading
  • Preventing execution of queries with unwanted objects
  • Filtering metadata by database, schema and object names, by object types.
  • Saving all metadata information to XML file for future modification and faster loading
  • Working without live database connection ("Offline mode")
  • Customizing SQL query text formatting rules
• Several stlyes of visualizing joins at the Design Pane
  • MS Access style
  • SQL Server Enterprise Manager style
• Miscellaneous features
  • Ability to translate interface of Active Query Builder to any language
  • Ability to switch languages in run-time
  • Ability to detect SQL Syntax dialect automatically
• Support for various SQL Dialects
  • Microsoft SQL Server
  • Oracle
  • Microsoft Access
  • MySQL
  • PostgreSQL
  • InterBase
  • Firebird
  • IBM DB2
  • Teradata
  • Sybase ASA/ASE
  • Informix
  • SQLite
  • ANSI SQL/89
  • ANSI SQL/92
  • ANSI SQL/2003
• Full set of database connectivity options
  • Generic event-driven metadata provider

Learn more about Active Query Builder

Purchase Standard Edition of Active Query Builder