Sybase ASE ddlgen导出表结构-优快云博客

本文介绍如何使用 Sybase 的 DDLGen 工具来生成数据库对象的定义脚本，包括存储过程、数据库结构、表结构及视图等。通过设置不同的参数选项，如用户名、密码、服务器名称等，可以灵活地生成所需的 DDL 脚本。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

事先配置好必要的环境变量，如果有则不用

export SYBROOT=/opt/sybase

export SYBASE_JRE6=/opt/sybase/shared/JRE-6_0_24_32BIT

1、存储过程

/opt/sybase/ASEP/bin/ddlgen -Usa -P -SSYB_SERV -Duserdb -TP -N% -O proc.ddl

2、数据库

/opt/sybase/ASEP/bin/ddlgen -Usa -P -SSYB_SERV -Duserdb -TDB -Nuserdb -O db.ddl

3、表结构

/opt/sybase/ASEP/bin/ddlgen -Usa -P -SSYB_SERV -Duserdb -TU -N% -O table.ddl

4、视图

/opt/sybase/ASEP/bin/ddlgen -Usa -P -SSYB_SERV -Duserdb -TV -N% -O view.ddl

PS:

-SSYB_SERV 还可以为-SIP:port

语法说明：

Usage: ddlgen [Option1][Option2][Option3].... where options are..
_____________________________________________________________________________

Option Parameter Required Default Description
_____________________________________________________________________________

-U <user name> Yes NA User Name

-P <password> Yes NA Password for Server

-S     <Server Name |          Yes      NA             Server Name OR
          [ssl]:hostName:port >                          [ssl]:<hostName>:<port>
-T     <object type>            No      DB             Type of the object
                                                         Refer Docs for this

-N <object name> No Default DB Object Name

-D     <database name>          No      Default DB     Database in which
                                          for the login the object specified
                                                         in -N option exist

-X     <extended object type>   No      NA             Used in conjunction
                                                         with some -T option
                                                         Refer Docs for this

-F     <filter object type>     No      None           Used in conjunction
                                                         with some -T option
                                                         Refer Docs for this

-J <client charset name> No Server's Character set used
character set by the ddlgen client

-I     <interfaces file name>   No      Default        Interfaces File to
                                                         be used for decoding
                                                         the Server's Host
                                                         Name and Port Number

-O     <output file name>       No      stdout         File to be used for
                                                         writing the
                                                         DDL Output

-E <error file name> No stdout File to be used for
logging the errors

-L <progress log file name> No No Logging File to be used for
logging the progress

-V <version no.> No NA Prints the Version
of the DDLGenerator