Product Home
DTM Schema Reporter Online Documentation Prev Page Prev Page
General Information
Product Profile
Product Editions
System Requirements
User Interface
Connect
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Reports
Schema Report
Security Report
Statistics
Object Descriptions
Export
Import
Output Options
Program Settings
Report Styles
Tables Selection
Objects Selection
Properties Selection
Execution Console
Tuning and Localization
Log Viewer
Advanced
Project File
Command Line
ER-model
Property Editor
SQL Console
Hot keys
Note Editor
Additional Information
Database Utilities
Licence Agreement
Demo and Full versions
Product Ordering
Install
Uninstall
Upgrade
Support
Trademark Information
Glossary

SQL Console

The tool has a special window where you can specify and execute any SQL statements. You can copy the results of executing a statement onto the clipboard or export it into various formats like text, SQL, HTML, XML or Microsoft Excel. Placing the mouse cursor over the column header will show the type of data stored in this field.

Important: the SQL console does not show any warning before data deletion or modifying.

Note: SQL console shows only begins of large strings. Typically you can view up to 512 first symbols.

DTM Schema Reporter: SQL Console

Menu item "Load" allows you to read SQL script from the external file.

There is a picture of local menu accessed by the right click inside the results window.

DTM Schema Reporter, SQL console: context menu for result set