SHOW TABLES includes which tables in its results?

• A. Yes, dropped tables that are still within Time Travel retention
• B. No, no dropped tables are shown
• C. Only provider tables are shown
• D. It depends on the time travel setting

Answer: (A)

Time Travel retention affects what metadata commands can reveal. When you drop a table, it isn’t removed permanently right away; it remains recoverable for the duration of the Time Travel retention. SHOW TABLES will include those recently dropped tables in its results as long as they’re still within that retention window, so you can see them and potentially undrop them. Once the retention period passes, they no longer appear. This is why listing dropped tables within the Time Travel window is the correct behavior.