Select * from tab equivalent in SQL Server

 Oracle SQL:: Select * from tab;

MS SQL Server::  

select TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE
from INFORMATION_SCHEMA.TABLES order by TABLE_TYPE,TABLE_NAME