What is the Snowflake SQL command SHOW TABLES LIKE 'table_name%'; used for?
SHOW TABLES LIKE 'table_name%';
Snowflake SHOW TABLES ... LIKE '<pattern>' filters table names using SQL wildcard matching. Because % matches zero or more characters after table_name, table_name% returns tables whose names start with table_name.
SHOW TABLES ... LIKE '<pattern>'
%
table_name
table_name%
Community Discussion