SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'back_office'
AND table_name = 'incoming_order'
ORDER BY ordinal_position
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'back_office'
AND table_name = 'payment'
ORDER BY ordinal_position
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'back_office'
AND table_name = 'pension_calculation'
ORDER BY ordinal_position