[TSQL]How to get list of Table in MS-SQL

USE [TABLE_NAME]
SELECT *
FROM sys.Tables
ORDER BY NAME