SELECT
column_name,
character_maximum_length
FROM information_schema.columns
WHERE table_schema = 'back_office'
AND table_name = 'operation_type'
AND column_name IN (
'code',
'name',
'short_name',
'group_code',
'service_type',
'name_for_statement'
)
ORDER BY ordinal_position;