Wednesday, November 16, 2011

How to list all Views in the database?


Method 1 : SELECT name FROM SYS.OBJECTS WHERE type=’V’
Method 2 : SELECT name FROM SYS.ALL_OBJECTS WHERE type=’V’
Method 3 : SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
Method 4 : SELECT name FROM SYS.VIEWS