Toad World® Forums

Archive Automation


I’d like to find a way to list all tables in local storage and then export to a file using automation. The reason for this is that I want to write an automation to auto delete data in all local storage tables that is more than two years old. I know how to automate the actual deletion - I just can’t find a way to automatically list all table names to a file. Any ideas?


show tables from databasename


Doh - so easy when you know how!

Many thanks Debbie