How to list tables in MSSQL

SELECT TABLE_SCHEMA,TABLE_NAME,
OBJECTPROPERTY(object_id(TABLE_NAME),
N'IsUserTable') AS type
FROM INFORMATION_SCHEMA.TABLES