DECLARE @table_Name SYSNAME = 'Q'
 
 
SELECT t.TABLE_NAME, 
       c.COLUMN_NAME, 
       c.DATA_TYPE, 
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       ISNULL(CHARACTER_MAXIMUM_LENGTH,0 ) AS SIZE
FROM INFORMATION_SCHEMA.TABLES AS t
INNER JOIN INFORMATION_SCHEMA.COLUMNS c ON 
    (t.TABLE_NAME = c.TABLE_NAME) 
WHERE t.TABLE_NAME= @table_Name
ORDER BY t.TABLE_NAME