I would like to list all empty tables in my database Athena.
I tried :
select table_schema, table_name from information_schema.tables
where table_schema = 'database'
But like this I list only table name with database name. Thanks for your help.
See Question&Answers more detail:os