From: Chris McMahon <christopher.mcmahon@...>
Date: 2006-12-21T09:45:05+09:00
Subject: ruby ODBC: what is returned by 'columns'?


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?