SybaseASE下用ddlgen导出表结构由tedabc在周六,2009-12-1921:55提交脚本内容#exportTable.shexportSYBROOT=/syb64bitexportSYBASE_JRE=/syb64bit/shared/jre142_015>table.ddlcattable.list|whilereadtabdoddlgen-Usa-P-SSYB_SERV-Duserdb-TU-N${tab}-Otmp.ddlcattmp.ddl|sed'/^create/,/^go/!d'>>table.ddldonermtmp.ddlddlgen的其他用法:1、存储过程ddlgen-Usa-P-SSYB_SERV-Duserdb-TP-N%-Oproc.ddl2、数据库ddlgen-Usa-P-SSYB_SERV-Duserdb-TDB-Nuserdb-Odb.ddl3、表结构ddlgen-Usa-P-SSYB_SERV-Duserdb-TU-N%-Otable.ddl4、视图ddlgen-Usa-P-SSYB_SERV-Duserdb-TV-N%-Oview.ddlddlgen使用===========================================================作者:feimei(http://feimei.itpub.net)发表于:2006.06.1314:15分类:SYBASE出处：http://feimei.itpub.net/post/10248/113937---------------------------------------------------------------ddlgen使用一.使用位置$SYBASE/ASEP/bin/ddlgen二.导出DDL语句ddlgen-Utips_prod-Ptips_prod-STIPS-Dtips_ini导出tips_ini库中所有对象的DDL语句/export/home/sybase/ASEP/bin/ddlgen-Utips_prod-Ptips_prod-STIPS-Dtips_ini-TU-Nt%导出tips_ini库中tips_prod用户下所有以t开头的用户表的DDL语句-T所有数据库对象类型C–cacheI–indexRS–remoteserverDB–databaseKC–primary/uniquekeyconstraintsSG–segmentD–defaultTR–triggerDBD–databasedeviceL–loginU–tableDPD–dumpdeviceP-storedprocedureUDD–user-defineddatatypeEC–executionclassR–ruleUSR–userEG–enginegroupRI–RIconstraintsV–viewGRP–usergroupRO–roleXP–extendedstoredprocedure-X-F可用与扩展或过滤对象类型-N对象名称（必须同-T一起使用,缺省–N%）语法：db_name.owner.table_name.index–XOUor–XOD:Theseoptionsareusedincombinationwith–TU:with–XOU,onlyusertablesareincluded;with–XOD,onlyproxytables.Specifyingjust–TU,without–X,includesbothusertablesandproxytables.其他的参数选项：-F{TR|I|KC|RI|%}:Forusertablesonly,doesnotgenerateDDLfortriggers(TR),indexes(I),primary/uniquekeyconstraints(KC),orRIconstraints(RI)forthosetable(s).Theseoptionsmaybecombinedwithcommas.%excludesalloftheabove;–Falonehasnoeffect.–Ooutput_file:OutputfilenameforthegeneratedDDL(default=stdout)–Eerror_file:Filetologerrorsinto–Jcharacter_set:Clientcharacterset–v:Displaysddlgenversioninformation