PowerDesigner如何导出SQL
来源:互联网 发布:网红经济学数据 编辑:程序博客网 时间:2024/05/16 14:44
'******************************************************************************
'* File: name2comment.vbs
'* Purpose: Database generation cannot use object names anymore
' in version 7 and above.
' It always uses the object codes.
'
' In case the object codes are not aligned with your
' object names in your model, this script will copy
' the object Name onto the object Comment for
' the Tables and Columns.
'
'* Title:
'* Version: 1.0
'* Company: Sybase Inc.
'******************************************************************************
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
'把列name和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
执行。再执行步骤一到步骤五
- PowerDesigner如何导出SQL
- PowerDesigner如何导出SQL
- PowerDesigner如何导出建表sql脚本
- powerdesigner 15 如何导出sql schema
- PowerDesigner如何导出建表sql脚本
- PowerDesigner导出SQL
- powerdesigner导出sql脚本
- PowerDesigner导出SQL
- PowerDesigner导出SQL
- powerdesigner导出sql
- PowerDesigner:导出SQL脚本
- PowerDesigner 导出 sql 语句
- PowerDesigner:导出SQL脚本
- PowerDesigner导出sql
- PowerDesigner导出所有SQL脚本
- PowerDesigner:[5]导出SQL脚本
- PowerDesigner 9 如何导出WORLD
- PowerDesigner如何导出数据库文档
- BestCoder 1st Anniversary ($) 题解
- 制作HTML5海报
- Xshell 4 SSH隧道跳转访问局域网服务器
- string.find()函数、 strncat函数、strncmp函数的用法
- wpf的附加事件
- PowerDesigner如何导出SQL
- 八大排序算法-shell 排序
- 恐高的鸟
- wpf 如何在后台设置附加属性的值
- PAT (Advanced Level) 1046. Shortest Distance (20) 求环中两点之间的距离
- 901-1注册表相应操作
- 3.2.1 正则表达式的语法(2)
- uva 725 Division
- Leetcode: Reverse Linked List