INFORMATION_SCHEMA.TABLES

--Script for list of tables in database

SELECT * FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE='BASE TABLE'

--Script for list of tables count in database

SELECT  COUNT(*) FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE='BASE TABLE'

--Script for list of tables particular schema level

SELECT * FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA='dbo'