Dropping ODBC Table

  • Thread starter Thread starter jer99 via AccessMonster.com
  • Start date Start date
J

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
 
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.
Click to expand...

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]
 
Back
Top