title: Snowflake - Query to check if given schema is empty i.e. no object in schema
body: <p>I am trying to create single query which can tell if given snowflake schema is empty so that it can be dropped.</p>
  <p>I have few SQLs created which queries the <code>INFORMATION_SCHEMA</code> views - tables, views, sequences to check if any object created. In this way I have to create multiple queries which returns flag values if it has table/view in given schema.  This query becomes lengthy and multiple hits.</p>
  <p>I am looking for single query which can tell me if given schema is empty?</p>