SELECT
    COLUMN_NAME 列名,
    DATA_TYPE 字段类型,
    CHARACTER_MAXIMUM_LENGTH 长度,
    COLUMN_COMMENT 名称
    FROM
    INFORMATION_SCHEMA.COLUMNS
    where
    table_schema =’cloudscape.company’
    AND
    table_name = ‘vehicleparameter’