06 March,2013 by Jack Vamvas
Question: How can I list all all SQL Views in a SQL Server database?
Answer: Use the sys.objects system SQL View and the type column to choose just the Views. Try not to use the sys.sysobjects sy as it’s a deprecated view , to be decommissioned at some point in the future
USE Database_name GO --Method 1 select [name] from sys.objects where type = 'V' order by [name] --Method 2 select * from sys.views --Method 3 select * from information_schema.tables where table_type = 'view'