Display all tables in sql server

Hi,

We used the show tables command in mysql. But, here in Sql Server to display all tables we need to write select * from information_schema.tables command in order to display all tables.

Cheers!!!

Ujjwal B Soni