DTM Schema Inspector

DTM Schema Inspector is a comprehensive application that facilitates a user-friendly workspace for browsing and managing database schemas.

It features support for snapshots that enable you to access older revisions of database objects, an integrated search function for large-sized schemas, along with exporting options to SQL scripts, among others.

After a speedy setup operation that shouldn't give you any trouble, you're welcomed by a large window with a simple design and well-structured layout.

Needless to say, you can get started by establishing a database connection to Microsoft SQL Server, Oracle Database, MySQL, Interbase/Firebird, IBM DB2 or PostgreSQL. It's possible to create and manage multiple profiles, as well as to save and export settings to file. The connection can be tested before committing modifications.

DTM Schema Inspector is also capable of connecting to existing and configured ODBC data sources, DSN files and OLD DB providers, as well as desktop data files, offering support for text (.txt, .csv), Microsoft Access (.mdb, .accdb), dBase, FoxBase and FoxPro (.dbf), Excel (.xls, .xlsx), Paradox (.db), FoxPro database container (.dbc) and SQLite database.

After loading contents, you can inspect data types, tables, system tables, view and procedures, including text, properties, data, permission and operations. Snapshots can be saved and loaded from .sss filetypes.

You can copy object names, properties and text, save and edit object text, resort to a search function to track down a particular piece of information across large databases, set or remove filters, examine and truncate log details, export the database schema to file, as well as open and view the SQL console window.

It worked smoothly in our evaluation, without hanging, crashing or indicating errors. Surprisingly, it didn't put a strain on the computer's performance, running on a low amount of CPU and RAM.

To sum it up, DTM Schema Inspector comes bundled with rich options and configuration properties to help you explore and manage database schemas.