SQLServer获得数据库表信息脚本

2015-09-04 16:54:24  访问(1623) 赞(0) 踩(0)

select 
d.id as tableId,
d.name as tableName,
isnull(f.value,'') as tableComment,
u.uid as UserId,
u.name as tableUser,
DB_NAME() as DatabaseName,
d.crdate as CreateTime,
d.refdate as UpdateTime
from
sysobjects d
left join (select * from sys.extended_properties where minor_id = 0) f on d.id = f.major_id 
left join sysusers u on d.uid = u.uid
where
d.xtype='U' and d.name<>'dtproperties' 
order by d.name asc, d.id asc

标签：SQLServer获得数据库表信息脚本 

上一条：

下一条：

相关评论

发表评论

类型：	留言 建议 疑问
内容：
	(Alt+Enter)