Properties Editor

Table of contents

• Overview
• Toolbar controls
• Context menu
• DDL tab

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.