Power Desinger Learning Notes < a >

If a table has many fields (more than 30), one copy and paste is time consuming.  Is it convenient to be lazy, edit SQL scripts in advance, and then import SQL scripts into power Designer? Look at the following.

1. Open PowerDesigner, click the File menu;

2.

Select: Reverse enginer, then select Database in his submenu ...;

3. Select the DBMS (database management System) type, then click the OK button; Here is a demonstration of the Oracle database selected, depending on your needs. 4. Add script 5 by clicking the Add Files icon.

Locate the SQL script you want to import, click the Open button;

6.

Mouse click, OK button;

7.

Start Reverse engineer Build database .....

8.

Import Successful!

Power Desinger Learning Notes < a >