List all the views in a Database – TSQL SELECT SCHEMA_NAME(schema_id) AS schema_name ,name AS view_name FROM sys.views order by view_name GO