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 ">
-
- 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. isw.cut then
-
- Tab. Comment = tab. Name
-
- Dim Col 'running Column
- For each Col in tab. Columns
-
- Col. Comment = col. Name
-
- Next
-
- End if
-
- Next
-
- 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.