There are times when you want to find all of the views that are in your Microsoft SQL database.  Especially when there are 1,000’s of views.  Each with the naming convention of the previous 5 DBA’s personal whims.  Normally as a database ages the views will become duplicative and add to the general clutter that gets in the way of efficiency.

List all views in a database