SqlServer2000获得数据库表信息
2015-09-04 17:53:54 访问(1714) 赞(0) 踩(0)
select
d.id as tableId,
d.name as tableName,
isnull(f.value,'') as tableComment,
u.uid as UserId,
u.name as tableUser,
d.crdate as UpdateTime,
DB_NAME() as DatabaseName,
d.crdate as CreateTime,
d.refdate as UpdateTime
from
sysobjects d left join sysproperties f on d.id = f.id and f.smallid = 0
left join sysusers u on d.uid = u.uid
where
d.xtype='U' and d.status >= 0 and d.name<>'dtproperties'
order by d.name asc, d.id asc
标签：
SqlServer2000获得数据库表信息 
上一条：
下一条：
相关评论
发表评论