how to get an Oracle database / table schema using vb6

I would like to get the schema information for Oracle database and tables.

Such as the table names of the database and all table field names, datatypes, etc using vb6.

How?

Thanks for help in advance.

You need to know some information to start with. First who owns the tables? Hopefully it is not the sys or system user and it is the person who's login you used to connect to the Oracle database. If that is the case you can issue an SQL statement to get tables like this:

Code:

---

  strSQL = "Select table_name from UserTables"

---

that will return all of the tables owned by the login connected.

If you need table information from a schema other then the person who is logged in then you need to use something lile this:

Code:

---

    strSQL = "Select Owner,table_Name from all_tables Where Owner Not IN ('SYS','SYSTEM')"

---