QuestionQ46Verified/Load and leverage structured, semi-structured, and unstructured dataCopy linkReport a problemAsk AstroTutorSave questionWhat is the Snowflake SQL command SHOW TABLES LIKE 'table_name%'; used for?AIdentify any tables in a schema that include table_name.BIdentify any tables in a schema that start with the words table_name.CIdentify any tables in a schema that contain data that references a table named table_name.DIdentify any Snowflake objects in a schema that are associated with a table named table_name.Show AnswerAnswerExplanationSnowflake 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.Learn moreSnowflake SHOW TABLES documentationShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion