def test_add_column2(self):
        stmts = [CREATE_STMT2, "ALTER TABLE t1 DROP COLUMN c2"]
        inmap = self.std_map()
        inmap['schema public'].update({'table t1': {
            'columns': [{'c1': {'type': 'integer'}}, {'c2': {'type': 'text'}},
                        {'c3': {'type': 'date'}}]}})
        sql = self.to_sql(inmap, stmts)
        assert len(sql) == 1
        assert fix_indent(sql[0]) == "ALTER TABLE t1 ADD COLUMN c2 text"
return the values & release the memory
dataset/ETHPy150Open perseas/Pyrseas/tests/dbobject/test_column.py/ColumnToSqlTestCase.test_add_column2--crossover with--dataset/ETHPy150Open pydata/pandas/pandas/io/pytables.py/IndexCol.take_data