Reproduced:
powerdesigner16 is also applicable
Create a new Physical Data Model in powerBuilder, and create a new user table in it. The information is as shown in the figure below:
The SQL statement at this time can be Get it from the Preview view, as shown below:
The SQL statement generated at this time is There is no comment, and the sql statement may not be suitable for your corresponding database language. At this point, the following methods can be used to generate comments and select the required database language.
1. Generate comments for sql, the operation is as follows, I use PowerDesigner12.5, in which select Tools—-” Excute commands—–》Add the following information to the window opened by Edit/Run Script
‘******* ************************************************** *********************
‘* 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 style
‘The object Name onto the object Comment for
‘ the Tables and Columns.
‘
‘* Title:
‘* Version: 1.0
‘* Company: Sybase Inc.
‘***************************** *************************************************< /p>
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< br style="word-wrap:break-word; margin:0px; padding:0px">‘Use the statement as a table comment, but you don’t actually need to do this
tab.comment = tab.name
Dim col running column
for each col in tab.columns
Column name Merged with comment into 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
After clicking run, you can see that the preview window just now is as shown in the figure below
2, replace the database sql statement.
Select Database—“change current DBMS, select the corresponding database in the DBMS, such as Microsoft SQL Server 2005, click OK , And then select Database—“Generate Database option, select the save path of the generated sql file in the pop-up window, click OK, you can see that the generated sql language is completely in accordance with the sqlserver2005 standard.