List All Tables in a Database in SQLSERVER2008

SELECT TABLE_SCHEMA + '.' + TABLE_NAME [Table Name], *
       FROM INFORMATION_SCHEMA.TABLES
       WHERE TABLE_TYPE = 'BASE TABLE'
       ORDER BY 1