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

2009-12-14 18:51| 发布者: admin| 查看: 40| 评论: 0|原作者: 云天河

〖SQLSERVER2000 sql_pu......

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"

收藏分享邀请

下级分类

GMT+8, 2024-9-30 07:21 , Processed in 0.108916 second(s), 12 queries , Gzip On, MemCache On.

		自动登录	找回密码
密码			注册

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

最新评论

相关分类

下级分类