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 ='视图名'

浙公网安备 33010602011771号