This is what I want to do:
1. Delete all tables in database with table names that ends with a
number.
2. Leave all other tables in tact.
3. Table names are unknown.
4. Numbers attached to table names are unknown.
5. Unknown number of tables in database.
For example:
(Tables in database)
Account
Account1
Account2
Binder
Binder1
Binder2
Binder3
.......
I want to delete all the tables in the database with the exception
of Account and Binder.
I know that there are no wildcards in the "Drop Table tablename"
syntax. Does anyone have any suggestions on how to write this sql
statement?
Note: I am executing this statement in MS Access with the
"DoCmd.RunSQL sql_statement" command.
Thanks for any help!