select b.name,b.create_date,a.name,
(select value from sys.extended_properties
where major_id=a.object_id and minor_id=a.column_id)
from sys.columns as a
left join sys.tables as b on(a.object_id=b.object_id)
where b.name='要读取的表名'读取指定表的创建信息
select b.name,b.create_date,a.name,
(select value from sys.extended_properties
where major_id=a.object_id and minor_id=a.column_id)
from sys.columns as a
left join sys.tables as b on(a.object_id=b.object_id)
where b.name='要读取的表名'
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
