Product Home
DTM Schema Inspector Online Documentation Prev Page Prev Page
General
Product Profile
Connect to Database
Settings
Filter
Search
Object Tree
Operations
Export schema
Requirements
SQL console
Tips and FAQ
Troubleshooting
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Glossary

Product profile

DTM Schema Inspector is a set of powerful database schema management tools that let you work with database schemas more effectively. Schema Inspector allows you to:
  • access database schema information for various data sources simultaneously.
  • create, save, load and view schema snapshots.
  • view and export texts for database objects.
  • view properties of the objects.
  • observe and export tables' and views' data (text, XML, HTML, Microsoft Excel).
  • export database schema as a set of the SQL statements for data source or selected database.
  • search database objects by name, type, database name and objects text.
  • filtering options for database object trees (by name, type, database name or objects text).
  • drop and rename database objects, enable/disable triggers.
  • view acess rights for tables, columns and views.

Our software allows user to view lists of

  • tables with indexes, primary and foreign keys.
  • access rights for tables and columns.
  • system tables.
  • views or queries.
  • synonyms.
  • users (for MS SQL, Sybase and Oracle data sources).
  • databases (for MS SQL and Sybase data sources).
  • stored procedures
  • extended stored procedures (for MS SQL Server).
  • triggers (MS SQL, Sybase, Oracle and Interbase).
  • data types.
  • defaults (for MS SQL and Sybase).
  • rules (for MS SQL and Sybase data sources).
  • roles and server roles (for MS SQL Server).
  • type (insert, update, etc) and status (enabled or disabled) of the triggers (MS SQL Server and Oracle).