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