How to Get List of Tables in Database using Query in SQL Server 2008

Introduction: 

In this article I will explain SQL server query to get list of all tables in database or get list of all the tables in SQL server 2008 database.

Following two queries can be used to get list of all tables in database:

 USE “database Name”

SELECT * FROM information_schema.tables

                  OR   

USE “database Name”

SELECT * FROM SYS.tables

Result: