How to get a list of views in sql server

To get a list of views you can use the following query

Select * from sysobjects where type = 'V' and category = 0