获取所有用户表及根据表Id取得表字段信息

获取所有用户表及根据表Id取得表字段信息

获取所有用户表及根据表Id取得表字段信息 SQL SERVER 2000

sql_pub = 'select id, [name], crdate from sysobjects d where d.xtype = 'U' and d.name <> 'dtproperties' order by a.[name] asc'

sql_pub = ' SELECT ' & _

' a.[name] as '字段名称'' & _

' , (case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end) as 标识' & _

' , b.name 类型' & _

' , a.length 占用字节数' & _

' , (case when a.isnullable = 1 then '√'else '' end) 允许空' & _

' , isnull(e.text,'') 默认值' & _

' , cast(isnull(g.[value],'') as varchar(100)) AS 字段说明' & _

' FROM syscolumns a' & _

' left join systypes b' & _

' on a.xtype = b.xusertype' & _

' left join syscomments e' & _

' on a.cdefault=e.id' & _

' left join sysproperties g' & _

' on a.id = g.id AND a.colid = g.smallid' & _

' where a.id = ' & table_id & _

' order by a.colorder'