Get List of Tables Existed from Current Database:
There are many ways to get 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
Hope it Helps!
-- For Getting all tables Information
select * from sys.objects where Type = 'u'
-- For Getting all Procedures
select * from sys.objects where Type = 'p'