DTM SQL editor: Schema object additional information

Table of Content

General Information
Product Features
Database Connection
Product Settings
SQL Builder
Plug-ins and SDK
Plug-ins Library
- General Information
- By DBMS
  - SQL Server
    - Run Query Analyzer
  - Oracle
    - Run SQL*Plus
  - General
- By Functions
  - Editors
  - Common
    - Run WinDiff
    - Save/Load History
  - Preprocessors
    - External preprocessor
    - Simply preprocessor
  - After Execution Plug-ins
    - Run after script execution
Additional Information
SQL quick reference

Schema object additional information

You can see the additional database object information window at the left-lower corner of the main program window:

DTM SQL editor: database object information

This window allows you to view object text and properties, to view data from the tables or views, to view access rights for tables, views and columns (if your driver and DBMS support it) and to perform some usual operations same as object dropping or renaming. Please switch to the "Properties" tab for view the properties of the object:

DTM SQL editor: database object additional properties

You can view the object access rights using the "Permissions" tab:

DTM SQL editor: database object permissions

If you want to rename or drop database object, use "Operations" tab:

DTM SQL editor: database object operations