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

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