List all the Tables from Current Database

There are many ways to All the Table from a Databases.

The following SQL Script helps to List the tables, which are all existsed in a current database

select * from sys.tables

GO

select * from Information_Schema.tables

GO

Select * from Sysobjects where xtype='U'

GO