Altova DatabaseSpy 2024 Professional Edition

In DatabaseSpy, tables are shown with the dbs_ic_table icon. Depending on the database kind, tables may appear either under a database (catalog) dbs_ic_database or under a schema dbs_ic_schema.

 

In the Online Browser, the hierarchical structure of the table is displayed when you expand the dbs_ic_table [Table] node. The "Columns", "Keys", "Check Constraints", "Indexes" (and "Triggers", if applicable) folders group together the respective objects of the same type, if they exist.

dbs_table_01

Where applicable, you can optionally group tables of a given catalog or schema into user and system tables. To toggle this option on or off, right-click the "Tables" folder and select Sort into User and System tables from the context menu.

 

As a rule of thumb, you can right-click any database object in the Online Browser in order to reveal and run commands applicable it. For example, by right-clicking a "Tables" folder which contains multiple tables, you can drop multiple tables in the same operation.

© 2017-2023 Altova GmbH