list database and tale in terasata

sal21 · #1 (**permalink**) 01-19-13, 16:50

i nee to lisr all data base and related table in teradata srver with vb6 classic,how to?
example:

db1
- tble1
- tble2
db2
tble7
- tble9
...
ecc

loquin · #2 (**permalink**) 01-29-13, 14:15

I assume you already know how to connect to the database using ADO (to retrieve data.)

Take a look at ADOX (ADO database extensions) - they give you the tools to interrogate (and modify, if you have the access) the database schema.

sal21 · #3 (**permalink**) 01-29-13, 15:37

Quote:

Originally Posted by loquin

I assume you already know how to connect to the database using ADO (to retrieve data.)

Take a look at ADOX (ADO database extensions) - they give you the tools to interrogate (and modify, if you have the access) the database schema.

based:
assume you already know how to connect to the database using ADO (to retrieve data.)

no i dont know with ADO

i open via DSN and odbc

Internet Services

Web Development

Digital Marketing

Consumer Tech