Alternate for sp_help ( Alt + F1)

Gives only the needful Info :

SELECTO.name AS TableName, C.Name As ColumnName,T.name AS DateType,T.max_length AS [Length], T.precision AS Precesion, T.scale AS Scale,
CASEWHEN C.is_identity = 1 THEN 'Y' ELSE 'N' END AS [Identity],
CASEWHEN C.is_nullable = 1 THEN 'Y' ELSE 'N' END AS Nullable
FROMSYS.OBJECTS O
INNERJOIN SYS.columns C ON C.object_id = O.object_id
INNERJOIN SYS.types T ON T.system_type_id = C.system_type_id
WHERETYPE = 'U' AND T.name <> 'SYSNAME'
-- AND O.Name = 'Employee'ORDER
BY O.name, C.column_id