sql 2005 跟据视图名列出视图所有列的描述
select vcu.view_name,tbd.* from (
select tmp.tablename,tmp.columnname,ep.* from sys.extended_properties ep join
(select tb.name as tablename, cl.object_id,cl.name as columnname,cl.column_id from sys.columns cl join
(select name,object_id from sys.tables )tb
on cl.object_id=tb.object_id) tmp
on ep.major_id=tmp.object_id and ep.minor_id = tmp.column_id ) tbd join
(select * From INFORMATION_SCHEMA.VIEW_COLUMN_USAGE ) vcu
on tbd.tablename=vcu.table_name and tbd.columnname=vcu.column_name
where view_name ='视图名'
select tmp.tablename,tmp.columnname,ep.* from sys.extended_properties ep join
(select tb.name as tablename, cl.object_id,cl.name as columnname,cl.column_id from sys.columns cl join
(select name,object_id from sys.tables )tb
on cl.object_id=tb.object_id) tmp
on ep.major_id=tmp.object_id and ep.minor_id = tmp.column_id ) tbd join
(select * From INFORMATION_SCHEMA.VIEW_COLUMN_USAGE ) vcu
on tbd.tablename=vcu.table_name and tbd.columnname=vcu.column_name
where view_name ='视图名'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16436858/viewspace-631197/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
SQL 扫描参数（SARG）
请登录后发表评论
登录
全部评论
