|
Database Schema Report contains information about database
objects: tables, views, stored procedures, triggers, data types,
etc.
DTM Schema Reporter allows you to choose which tables, views,
procedures, or synonyms will be included in the report and to
set the object's order. Moreover, the program allows you to create
or edit descriptions for tables,
columns, views, synonyms, and procedures; these descriptions will
be included in the report as well.
DTM Schema Reporter allows you to include the following objects in
the schema report:
| Object
|
Item
|
Description
|
| Table |
Column data type |
System or user defined data type like int or varchar2. |
| |
Column size (width) |
For sizable data types like char or varchar only. |
| |
Column nullability |
Does column accept NULL values or no. |
| |
Column default |
Default value for the column. |
| |
Check constraints |
Table and column level value limitations. |
| Table |
Description |
Table description |
| Column |
Description |
Column description |
| Table |
Primary key |
Key name and columns |
| Table |
Indexes |
Index name, indexed columns and index properties |
| Table |
Triggers |
Table level trigger name and properties |
| Table |
Foreign keys (relationships) |
Key name, columns and linked table information |
| Table |
Dependencies |
Depended objects of the table |
| View |
Column list |
List of column provided by view |
| View |
Dependencies |
Depended objects of the view |
| Synonym |
|
Basic information about synonyms |
| View |
Triggers |
Triggers associated with the view |
| Procedure/Function |
Parameters |
List of parameters with name and data type |
| Procedure/Function |
Dependencies |
Depended objects of the procedure or function |
| Rule |
|
Basic information for rule (Microsoft SQL Server only) |
| Database |
Trigger |
Database level triggers information (Microsoft SQL Server
only) |
| Table. column, view or procedure |
Extended properties |
Extended properties of the database object |
| Database |
Data type |
Name, code, parent type (if applicable), searchable, nullable,
etc. |
"With DDL script" option means the program should include SQL
statement for the object into the schema report. It is switched off
by default. |
