codekingpro/portable-devtools

1"""call using an open ADO connection --> list of table names"""
2from . import adodbapi
3
4
5def names(connection_object):
6    ado = connection_object.adoConn
7    schema = ado.OpenSchema(20)  # constant = adSchemaTables
8
9    tables = []
10    while not schema.EOF:
11        name = adodbapi.getIndexedValue(schema.Fields, "TABLE_NAME").Value
12        tables.append(name)
13        schema.MoveNext()
14    del schema
15    return tables
16