


  
  <section id="databases-tables-views">
<h1>Databases, Tables &amp; Views<a class="headerlink" href="#databases-tables-views" title="Link to this heading">¶</a></h1>

<p>All data in Snowflake is maintained in databases. Each database consists of one or more schemas, which are logical groupings of
database objects, such as tables and views. Snowflake does not place any hard limits on the number of databases, schemas
(within a database), or objects (within a schema) you can create.</p>
<p><strong>Next Topics:</strong></p>
<div class="toctree-wrapper compound">
<ul>
<li class="toctree-l1"><a class="reference internal" href="tables-micro-partitions">Understanding Snowflake Table Structures</a></li>
<li class="toctree-l1"><a class="reference internal" href="tables-temp-transient">Working with Temporary and Transient Tables</a></li>
<li class="toctree-l1"><a class="reference internal" href="tables-external">Working with external tables</a></li>
<li class="toctree-l1"><a class="reference internal" href="search-optimization-service">Search Optimization Service</a></li>
<li class="toctree-l1"><a class="reference internal" href="views-introduction">Overview of Views</a></li>
<li class="toctree-l1"><a class="reference internal" href="views-secure">Working with Secure Views</a></li>
<li class="toctree-l1"><a class="reference internal" href="views-materialized">Working with Materialized Views</a></li>
<li class="toctree-l1"><a class="reference internal" href="table-considerations">Table Design Considerations</a></li>
<li class="toctree-l1"><a class="reference internal" href="object-clone">Cloning considerations</a></li>
<li class="toctree-l1"><a class="reference internal" href="tables-storage-considerations">Data storage considerations</a></li>
</ul>
</div>
</section>




Databases, Tables & Views¶