How To Get List of Tables in SQL Server

Using Following SQL Query you can get list of tables in SQL Database

SELECT name [Table Name]

FROM sysobjects

WHERE xtype = 'U'