Simular DESC TABLE de Oracle en SQL Server

USE MiBaseDeDatos
GO
SELECT T1.NAME AS [Tabla], T2.NAME AS [Campo], T3.NAME AS [Tipo], T3.LENGTH AS [Tamaño]
FROM SYS.OBJECTS AS T1
INNER JOIN SYS.COLUMNS AS T2 ON T1.OBJECT_ID = T2.OBJECT_ID
INNER JOIN SYS.SYSTYPES AS T3 ON T2.USER_TYPE_ID = T3.XUSERTYPE
WHERE T1.TYPE ='U'
ORDER BY T1.NAME