tanjiyong138 发表于 2011-06-04 10:02

作得漂亮，赞一下

select a.name as name,b.name as type,a.length as length ,a.type as flg ,a.prec as prec,a.scale as scale ,a.status as status, c.text as deftext
from syscolumns a,systypes b,syscomments c
where a.usertype=b.usertype anda.id=object_id('"+tablename+"') and a.cdefault*=c.id
order by a.colid

联立取一下table中的column中的default表达式。

andkylee 发表于 2011-06-04 13:32

Sybase自动生成数据库内所有表的DDL语句的存储过程
http://www.dbainfo.net/get-table-definition-syntax-sp_gettabledll.htm

Eisen 发表于 2011-06-08 09:04

select a.name as name,b.name as type,a.length as length ,a.type as flg ,a.prec as prec,a.scale as sc ...
tanjiyong138 发表于 2011-06-04 10:02 http://bbs.chinaunix.net/images/common/back.gif


    怎么越看越眼熟啊……

andkylee 发表于 2011-06-08 23:25

回复 3# Eisen


    你的那个工具不是能够直接从数据库中抽取出来对象的DDL语句嘛。
页: [1]
查看完整版本: 作得漂亮，赞一下