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 = 'student' -- 只需修改这里的表名
ORDER BY t.table_name