Dropping ODBC Table

[jer99 via AccessMonster.com]

I utilize ODBC drivers to connect to an Oracle back end.
I need to check for the existance of a table in Oracle and if it exists, drop
the table and commit.
Anyone have any clues as to how to do this or where to look?

Jerry

 

[John W. Vinson]

I utilize ODBC drivers to connect to an Oracle back end.
I need to check for the existance of a table in Oracle and if it exists, drop
the table and commit.

You'll probably want to construct a SQL string and execute it as a PassThrough
query. See PassThrough in the online help.

John W. Vinson [MVP]