How to get table list by SQL?

We can get list of tables in our database:

1 SELECT
2 TABLE_SCHEMA,
3 TABLE_NAME,
4 OBJECTPROPERTY(object_id(TABLE_NAME),
5 N'IsUserTable') AS type
6 
7 FROM
8 
9 INFORMATION_SCHEMA.TABLES

Reference