Database Contextual Menu

The database contextual menu contains commands that let you perform a wide range of actions.

This menu contains the following commands:

Command

Description

Generate Scripts

Generates a script to prepare the replication of tables.

Generate and Execute Scripts

Generates and executes a script on the connected database to replicate tables.

Generate Database

Generates a database creation script from the associated PDM (see Data Modeling > Working with Data Models > Generating and Reverse-Engineering Databases > Generating a Database from a PDM).

Modify Database

Modifies an existing database schema by synchronizing it with your model (see Data Modeling > Working with Data Models > Generating and Reverse-Engineering Databases > Modifying a Database).

Reverse Engineer Database

Reverse engineers an existing database schema into an existing PDM. The database schema can either be from script files or from a data source (see Data Modeling > Working with Data Models > Generating and Reverse-Engineering Databases > Reverse Engineering a Database into a PDM).

Connect

Connects to a data source (see Core Features Guide > The PowerDesigner Interface > Getting Started > Connecting to a Database).

Execute SQL

Opens the Execute SQL Query window to let you send SQL queries to a connected data source and display the result. If you are not already connected to the data source, the Connect to Data Source window opens. Choose your connection profile, and click Connect to open the Execute SQL Query window. Enter one or more SQL statements in the dialog to query your database, and click the Run button to apply them to the data source, and display the query results in the Results window.