By executing the ‘SHOW TABLES’ command, we can list all the tables in all the schemas even if we do not have access to all the tables

By executing the ‘SHOW TABLES’ command, we can list all the tables in all the schemas even if we do not have access to all the tables
A . TRUE
B. FALSE

View Answer

Answer: B

Explanation:

SHOW TABLES

Lists the tables for which you have access privileges, including dropped tables that are still within the Time Travel retention period and, therefore, can be undropped. The command can be used to list tables for the current/specified database or schema, or across your entire account.

The output returns table metadata and properties, ordered lexicographically by database, schema, and table name (see Output in this topic for descriptions of the output columns). This is important to note if you wish to filter the results using the provided filters. Please also note the comment on table metadata

The SHOW COMMAND does not cost you any compute resource as it does not use warehouse. It gets the result from metadata store. Please try it yourself. Run this command and go to query profile and see yourself