sp_tables lists all views in a database when used in the following format:
sp_tables @table_type = "’VIEW’"
