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
?
