SELECT 
    database AS db, 
    database AS schema_name, 
    table AS table_name, 
    name AS column_name, 
    type AS data_type 
FROM system.columns