Lets say I have created a view and I have forgotten the name i used for that particular view but I urgently need to update the query for the view. Is there a way to see all the views I have created so far? so as to help me identify the view that needs to be updated.

Answer 1

It depends on the database you are using (the software). For example, in SQL Server 2005 you'd use:
SELECT * FROM sys.views

Answer 2

I'm not sure what your using for running sql but usually in the sql ide you should see a list of all the tables in your product . well at least for all 2013