Sybase ASE ddlgen导出表构造

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

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

?