Main object is sys.tables. you can get all information about tables by query on sys.tables.
User databasename
Select * from sys.tables;.
SELECT SCHEMA_NAME(schema_id) AS table_schema_name, name AS table_Name
FROM sys.tables;
SCHEMA_NAME convert schema_id into schema name.