get the list of tables that r available in a particular database in sqlserver

select * from information_schema.tables

or

select * from sys.tables