Powerdesign Practical Skills

The exported table creation script table name contains quotation marks.
======================================
This is because of the setup problem in powerdesign. In the menu, choose database> edit current DBMS... in the left-side tree of the pop-up window, find SCRIPT> SQL> Format> casesensitivityusingquote and set this value to false.

Powerdesign export name as comment

======================================

First open PDM, tools-> execute commands-> edit/run script
Run the following script to copy the name to comment VB. Code {
Function onclick ()
{
Function onclick ()
{
Function onclick ()
{
Function onclick ()
{
DP. Sh. toolbar. copytoclipboard (this); Return false;
}
}
}
}
} "Href =" http://zhenggm.javaeye.com/blog/636514 ">

2. Option explicit
4. Validationmode = true
6. Interactivemode = im_batch
10. Dim MDL 'the current Model
14. 'Get the current active Model
16. Set MDL = activemodel
18. If (MDL is nothing) then
20. Msgbox"There is no current model"
22. Elseif not MDL. iskindof (pdpdm. cls_model) then
24. Msgbox"The current model is not an physical data model ."
26. Else
28. Processfolder MDL
30. End if
34. 'This routine copy name into code for each table, each column and each view
36. 'Of the current folder
38. Private sub processfolder (folder)
40. Dim tab 'running table
42. For each tab in folder. Tables
44. If not tab. isw.cut then
46. Tab. Comment = tab. Name
48. Dim Col 'running Column
50. For each Col in tab. Columns
52. Col. Comment = col. Name
54. Next
56. End if
60. Next
62. End sub

Option explicit validationmode = true interactivemode = im_batch dim MDL 'the current model' get the current active model set MDL = activemodel if (MDL is nothing) then msgbox "there is no current model" elseif not MDL. iskindof (pdpdm. cls_model) Then msgbox "the current model is not an physical data model. "else processfolder MDL end if 'this routine copy name into code for each table, each column and each view' of the current folder private sub processfolder (folder) dim tab 'running table for each tab in folder. tables if not tab. isshortcut then tab. comment = tab. name dim Col 'running column for each Col in tab. columns Col. comment = Col. name next end if nextend sub

then select the coment of table and column in database> Generate database> Options> table & column. The comment can be exported when the table is exported.