def load_table( table_name )
rows = @db.execute("SELECT tbl_name, sql FROM sqlite_master WHERE type = 'table' AND tbl_name = ?", table_name)
table_info = rows.first
table = nil
if table_info then
table = Amalgalite::Table.new( table_info['tbl_name'], table_info['sql'] )
table.columns = load_columns( table )
table.schema = self
table.indexes = load_indexes( table )
@tables[table.name] = table
else
table = Amalgalite::Table.new( table_name, nil )
cols = load_columns( table )
if cols.size > 0 then
table.columns = cols
table.schema = self
table.indexes = load_indexes( table )
@tables[table.name] = table
end
end
return table
end