TSQL select TABLE COLUMNS

USE database;
GO
SELECT t.name AS t_name,
SCHEMA_NAME(schema_id) AS s_name,
c.name AS column_name
FROM sys.tables AS t 
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
--WHERE c.name LIKE '%ID'
ORDER BY s_name, t_name;