Powerdesign Practical Skills

Source: Internet
Author: User
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 ">
  1. Option explicit
  2. Validationmode = true
  3. Interactivemode = im_batch
  4. Dim MDL 'the current Model
  5. 'Get the current active Model
  6. Set MDL = activemodel
  7. If (MDL is nothing) then
  8. Msgbox"There is no current model"
  9. Elseif not MDL. iskindof (pdpdm. cls_model) then
  10. Msgbox"The current model is not an physical data model ."
  11. Else
  12. Processfolder MDL
  13. End if
  14. 'This routine copy name into code for each table, each column and each view
  15. 'Of the current folder
  16. Private sub processfolder (folder)
  17. Dim tab 'running table
  18. For each tab in folder. Tables
  19. If not tab. isw.cut then
  20. Tab. Comment = tab. Name
  21. Dim Col 'running Column
  22. For each Col in tab. Columns
  23. Col. Comment = col. Name
  24. Next
  25. End if
  26. Next
  27. 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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.