The following will show a table of information about all tables available, including which are views and which are tables:

SELECT * FROM information_schema.tables

See Information Schema for more details.