• PwoerDesigner 生成数据库时没有中文注释


    快捷键 Ctrl+Shift+X打开窗口,运行

    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 comment 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
    '把列名称和comment合并为comment
    col.comment= col.name
    next
    end if
    next
      
    Dim view 'running view
    for each view in folder.Views
    if not view.isShortcut then
    view.comment = view.name
    end if
    next
      
    ' go into the sub-packages
    Dim f ' running folder
    For Each f In folder.Packages
    if not f.IsShortcut then
    ProcessFolder f
    end if
    Next
    end sub
    
    
  • 相关阅读:
    Flask商城项目详解
    《剑指offer》题解(Python版本)
    小程序学习笔记
    Html5 语义化标签
    常用页面布局
    css 语法记录
    vue-router 配置
    axios 配置
    Mybatis Generator
    openssl_pkcs7_verify的问题之旅
  • 原文地址:https://www.cnblogs.com/qzdd/p/13803967.html
Copyright © 2020-2023  润新知