List Tables

SELECT * FROM [information_schema].[tables] WHERE [TABLE_TYPE]='BASE TABLE';