|
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 Server 6.5 and higher data sources)
- stored procedures
- extended stored procedures (for MS SQL Server)
- triggers (Microsoft SQL Server, Sybase, Oracle and
Interbase)
- data types
- defaults (for Microsoft SQL and Sybase Server)
- rules (for some data sources)
- roles and server roles (for Microsoft SQL Server)
- type (insert, update, etc) and status (enabled or disabled) of
the triggers (MS SQL Server and Oracle)
The program has some settings and
options for the schema tree. The most important settings are
types of the objects.
The Schema->Find schema object
menu item helps you to find any object in database.
There is a picture of local menu accessed by the right click
inside the schema tree window.
Local menu (and toolbar buttons) provides:
- copy object name and text (source of stored procedure, for
example)
- save object's test to external SQL file
Our software allows user to export schema of the current
database as a set of SQL statements. You can use corresponding
toolbar button or "Export schema" item in Schema menu of the DTM
SQL editor.
The snapshot mechanism allows saving of the current state of
database schema to a separate file that can be opened and viewed
any time later.
Adding plug-ins to the DTM SQL editor
helps users to extend the functionality of the "Schema" tab local
menu (PT_SCHEMA plug-in type). It is also a possibility for the
third party developers wishing to make additions to the
program. |
