Select all tables from database

A quick reminder on how to select all tables from a MSSQL database. These two queries below can select all tables from any database including master database.

The number of tables produced by both queries will be the same, however the queries provide different information about the tables.

Give it a go.