conn = ODBC::connect(‘db’)
cols = conn.columns(‘table’)
cols.each do |col|
puts col.inspect
end
[“db_name”, “dbo”, “table”, “Created_”, 11, “smalldatetime”, 16, 16, 0,
nil, 1, nil, nil, 9, 3, nil, 1, “YES”, 111]
[“db_namet”, “dbo”, “table”, “Desc_”, 12, “varchar”, 100, 100, nil,
nil, 1, nil, nil, 12, nil, 100, 2, “YES”, 39]
etc.
it’s pretty clear that cols[x][3] is the column name and cols[x][5] is
the column data type, and [0], [1], [2] and maybe [6] are pretty clear,
but I’ve been unable to find out what the other values returned in the
array represent. Is that written down anywhere?