文章列表
select b.TABLE_NAME as "表名",
c.comments as "表说明",
b.COLUMN_ID as "字段序号",
b.COLUMN_NAME as "字段名",
b.DATA_TYPE as "字段数据类型",
b.DATA_LENGTH as "数据长度",
b.DATA_PRECISION as "整数位",
b.DATA_SCALE as "小数位",
a.comments a ...
- 2009-07-15 02:33
- 浏览 2745
- 评论(0)
SELECT
表名=case when a.colorder=1 then d.name else '' end,
表说明=case when a.colorder=1 then isnull(f.value,'') else '' end,
字段序号=a.colorder,
字段名=a.name,
标识=case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end,
主键=case when exists(SELECT 1 FROM sysobjects where xtype=' ...
- 2009-02-16 19:52
- 浏览 2490
- 评论(0)