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 ='视图名'
posted @ 2010-04-02 13:48  heshangwen  阅读(911)  评论(0编辑  收藏  举报