Viewing Metadata
Go Up to Inspecting Database Objects
The metadata which the Metadata tab of the object inspector displays depends on the database that is selected in the Tree pane, or the item that is selected in the Work pane.
To view metadata for an entire database Select a connected database in the Tree pane, and then double-click View Metadata in the Work pane. The metadata is displayed in a text window.
To view metadata for a specific database object perform one of the following actions:
- Select a database element from the hierarchy displayed in the Tree pane, and then in the Work pane double-click an object to display its Properties dialog. Click the Metadata tab to see the object’s metadata.
- Select a database element from the hierarchy displayed in the Tree pane, and then in the Work pane right-click a database object associated with that element and select Extract from the context menu.
For example, if you want metadata for domains only, expand the desired database hierarchy (if it is not already expanded), select Domains, double-click on a domain in the Work pane, and select the Metadata tab of the Properties dialog.
Use the drop-down list at the top of the dialog to select other objects associated with the database element.
The following table lists the items for which you can view metadata for associated objects with the object inspector.
Item | Displays |
---|---|
Blob Filters |
Blob filters definition |
Domains |
Metadata script, dependencies, data type, description, check constraints, and default values |
Exceptions |
Description, exception number, exception message, metadata script, and dependencies |
External Functions |
UDFs definition |
Generators |
Generator ID, current value, metadata script, and dependencies |
Stored Procedures |
Metadata script, procedure body, input parameters, output parameters, permissions, data, and dependencies |
Roles |
Role definition |
Tables |
Columns, data types, triggers, indexes, unique constraints, referential constraints, check constraints, metadata script, permissions, data, and dependencies |
Views |
Metadata script, permissions, data, and dependencies |