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

Operations with objects

There is a picture of local menu accessed by the right click on the tree item.

object's context menu

Using this menu you can:
  • copy name of the selected item onto clipboard
  • copy text of the selected item onto clipboard
  • save text of the selected item to SQL file

You can view the content of such objects as views (queries) and tables using "Data" tab. The program allows you to export the data into various formats (text, SQL, HTML, XML, RTF or Microsoft Excel) from that data grid.
Placing the mouse cursor over the column header will tell You the type of data stored in this field.

view table data


There is a picture of context menu accessed by the right click inside the data grid window.

results context menu


Moreover, you can use "Operations" tab at the right pane of the program window. Using it you can:
  • drop the current database item
  • rename object
  • enable or disable trigger (for MS SQL and Oracle data sources)

The program can remove many object types (e.g.: tables, views or triggers) by generating the corresponding DROP statement.

drop database object

You can rename few types of the objects for MS SQL Server and Oracle Server.

rename database object


You can enable and disable triggers for MS SQL Server and Oracle Server.

enable and disable trigger

See also: "objects tree"