获取MS SQL库数据字典
摘要:
SELECTsysobjects.nameAS[table],sysproperties.[value]AS表说明,syscolumns.nameASfield,properties.[value]AS字段说明,systypes.nameAStype,syscolumns.length,ISNULL(COLUMNPROPERTY(syscolumns.id,syscolumns.name,'Scale'),0)AS小数位数,syscolumns.isnullableASisnull,CASEWHENsyscomments.textISNULLTHEN''ELSE 阅读全文
posted @ 2007-01-29 14:01 木木凡 阅读(136) 评论(0) 推荐(0) 编辑