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. |