List Tables

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