PowerDesigner converting from SQL Server to annotated dictionaries and shortcut key operations

PowerDesigner's operations are often forgotten, so keep track of common functions and write down memos.

1. Modify the Reversed field

PowerDesigner when the database is reversed, the default is no comment and needs to be modified first.

Enter the following script:

{OWNER, TABLE, S, COLUMN, Dttpcode, LENGTH, SIZE, PREC, COMPUTE, Notnull, IDENTITY, DOMAIN, DEFAULT, COMMENT, extidentityi Ncrement, Extidentityseed}selectu.name,o.name,c.colid,c.name,case when (S.usertype < +) then S.name else X.name end , C.prec,c.length,c.scale,z.text, Case (C.status & 8) While 8 then ' NULL ' Else ' notnull ' End,case (C.status & +) W Hen ' identity ' Else ' end,case when (S.usertype < +) Then ' else s.name end,v.text,convert (varchar, ISNULL (P.[value], ")) As Text,case (C.status &) when IDENT_INCR (U.name + '. ' + o.name) else null end,case (C.status & 128)  When the Ident_seed (U.name + '. ' + o.name) else null endfromdbo.sysusers ujoin dbo.sysobjects o on (o.uid = U.uid and O.type in (' U ', ' S ', ' V ')) joins Dbo.syscolumns C on (c.id = o.id) left outer joins sys.extended_properties p on c.id = P.maj or_id and c.colid = P.minor_idleft outer join Dbo.systypes s on (C.usertype = S.usertype and S.xtype = C.xtype and C.usert Ype >= 0) LEFT OUTER join Dbo.systypes X on (S.usertype > + s.xtype = x.xtype and X.usertype not in (0, max) and x.us Ertype <) LEFT outer join Dbo.syscomments z in (z.id = o.id and Z.number = c.colid) left outer join Dbo.sysobjects D On (d.id = C.cdefault and d.category <> 0) left outer joins Dbo.syscomments V on (v.id = d.id) where 1 = 1[and u.name =%.q:owner%][and O.name=%.q:table%]order by 1, 2, 3

2. Configure PowerDesigner Database connection

Next, click "Finish"--"test Database"--return OK.

3. New Physical Data Model

After clicking "OK", the reverse PD dictionary will begin to work.

PowerDesigner Set chronograph display annotation options: selected edited table, right->properties->columns->customize Columns and Filter ( or directly with the shortcut key Ctrl+u)->comment (front tick)->ok

If an error occurs, "[MICROSOFT][ODBC SQL Server Driver][sql Server] cannot predefine the statement. SQLSTATE = 37000 "

WORKAROUND: Select the database-and change-current DBMS in the menu bar to select SQL Server2005 for the DBMS.

PowerDesigner Common shortcut keys

General shortcut keys

F4 Open the Check Model window to check the model
F5 if the diagram in the diagram window changes size, revert to the original size that is normal size
F6 the graph in the enlarged view window
F7 diagram in a zoomed-out window
F8 View all the contents of the diagram in the Diagram window
F9 Preview Diagram window
F10 in the diagram window with the height of a view shift+ click objects to select Objects continuously

Alt+0 Show or hide the browser window
Alt+1 Show or hide the output window
Alt+2 Show or hide the results List window
CTRL + Double click or ctrl + "+" to open the package diagram
Ctrl+tab switch size in the Diagram window, insert tabs in text, or toggle tabs in the property sheet window
Ctrl+page up/page down Toggle tabs in the Property sheet tab page
CTRL + Mobile window Disable docking feature
Ctrl+b finding objects in a browser window
Ctrl+d Open the Selection Diagram window, select the diagram
Ctrl+e Open the Report List window
Ctrl+f Open the Find Object window to find objects
Ctrl+j adjusting text in an object symbol
Ctrl+f4 Close the current diagram window
CTRL+ALT+F4 Close Model
CTRL+F6 switching between multiple property sheet windows
CTRL+SHIFT+F6 reversing between multiple property sheet windows
Ctrl+u back to the parent diagram
SHIFT+F2 Open Workspace
Shift+f3 Save Workspace
Shift+f4 Close Workspace

object Manipulation shortcut key table

Del Delete Object (confirmation required)
Shift+del Deleting objects (no confirmation required)
Alt+enter Open the property sheet for the selected object
Ctrl+k Paste as Shortcut
Ctrl+h Select connection: Horizontal connection
Ctrl+l Select connection: Vertical connection
CTRL + Change size Hold object Center Change object size
ctrl+shift+ changes the size of the object by changing the center of the object to resize it and maintain the aspect ratio of the original object

tool Panel shortcut key table

Double-click the Cursor tool (point)
Select all symbols in the diagram or CTRL + A
Double-click the Delete tool (delete) to delete all selected symbols (confirmation required)
Double-click the Move tool (Grabber) to display the global view double-click the Object tool
Select all symbols of the same type shift+ double-click the Object tool to keep the previous selection, adding all symbols of the same type selected

Drag and Drop accelerator table

shift+ Move Item Move symbol
CTRL + Move Item Copy symbol
Ctrl+shift+ Move Item Creation Shortcut List window shortcut key table
F2 Select the edited text
Ctrl+shift+space Select when to move forward
CTRL + A Select all rows
Ctrl+shift+a Cancel All Selections
CTRL + N or ctrl+i insert row
Ctrl+d Deleting rows

browser window shortcut key table

* (keypad) Expand all nodes in the active browser
+ (keypad) Expand child nodes in the active browser
-(keypad) closes all nodes in the active browser
F2 renaming
Ctrl+shift+f finding the selected object in the diagram

PowerDesigner converting from SQL Server to annotated dictionaries and shortcut key operations