[MSSQL] - Query List of All Tables from Specific Database

Tips of the day: The counter part of MYSQL "SHOW TABLES" command which shows all tables from a certain database is below. To show tables and views:

USE 
GO
SELECT * FROM INFORMATION_SCHEMA.TABLES

To show the tables alone.

USE 
GO
SELECT * FROM INFORMATION_SCHEMA.TABLES  WHERE TABLE_TYPE='BASE TABLE'

Good luck! Have Fun! :)