Properties Editor
Table of contents
Overview
When you open the Properties tab of the Database Object Editor, you'll see the following interface elements:
- Database object's properties: displays the properties of the current database object.
- Tabbed editors: These vary depending on your database. Depending on the database you're working with, you'll see different tabs reflecting that particular database's unique characteristics and requirements.
The Toolbar: provides tools for managing objects.
Toolbar controls
To interact with the Properties Editor page, you can use Toolbar controls at the bottom of the editor provides the following tools:
Button | Description |
---|---|
![]() | Deletes the item currently in focus. |
![]() | Saves the DDL script locally. |
![]() | Opens the DDL script in the SQL Editor. |
Context menu
The Properties of the sub-entities have context menus that offer the same commands as the Database Navigator. To access these menus, right-click on the item.
DDL tab
The DDL tab displays the Data Definition Language (DDL) script for the selected database object. It lets you view, and edit the SQL code used to create or modify the object.
Key features:
- View the exact structure of tables, indexes, views, and other objects.
- Copy or save the script for version control or manual execution.
- Open the script in the SQL Editor for modification.