2) select * from INFORMATION_SCHEMA.VIEWS where Table = 'viewname' Attempt 1 requires parsing the SQL statement that generated the view (not pretty). Secondary: It would also be nice to know how the ...