DOCUMENTATION
/
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
  1. Overview
    • SQL data types reference
    • SQL command reference
        1. Query syntax
        2. Query operators
        3. General DDL
        4. General DML
        5. All commands (alphabetical)
          • Accounts
          • Users, roles, & privileges
          • Integrations
          • Replication & failover
          • Sessions
          • Transactions
          • Virtual warehouses & resource monitors
          • Databases, schemas, & shares
              1. Database
              2. CREATE DATABASE
              3. ALTER DATABASE
                • DESCRIBE DATABASE
                  • DROP DATABASE
                    • UNDROP DATABASE
                      • USE DATABASE
                        • SHOW DATABASES
                          • Schema
                          • ALTER SCHEMA
                            • DESCRIBE SCHEMA
                              • CREATE SCHEMA
                                • DROP SCHEMA
                                  • UNDROP SCHEMA
                                    • USE SCHEMA
                                      • SHOW SCHEMAS
                                        • Share
                                        • ALTER SHARE
                                          • CREATE SHARE
                                            • DROP SHARE
                                              • SHOW SHARES
                                                • DESCRIBE SHARE
                                              • Tables, views, & sequences
                                              • Functions, procedures, & scripting
                                              • Streams & tasks
                                              • dbt Projects on Snowflake
                                              • Classes & instances
                                              • Machine learning
                                              • Cortex Search Service
                                              • Listings
                                              • Organization profiles
                                              • Security
                                              • Data Governance
                                              • Privacy
                                              • Data loading & unloading
                                              • File staging
                                              • Git
                                              • Alerts
                                              • Native Apps Framework
                                              • Streamlit
                                              • Notebook
                                              • Snowpark Container Services
                                          • Function and stored procedure reference
                                          • Class reference
                                          • Scripting reference
                                          • General reference
                                          • API reference
                                            ReferenceSQL command referenceDatabases, schemas, & shares

                                            Database, schema, and share commands¶

                                            Database, schema, and share commands enable you to manage your databases, schemas, and shares.

                                            Database¶

                                            • CREATE DATABASE

                                            • CREATE DATABASE (catalog-linked)

                                            • ALTER DATABASE

                                            • DESCRIBE DATABASE

                                            • DROP DATABASE

                                            • UNDROP DATABASE

                                            • USE DATABASE

                                            • SHOW DATABASES

                                            Schema¶

                                            • CREATE SCHEMA

                                            • ALTER SCHEMA

                                            • DESCRIBE SCHEMA

                                            • DROP SCHEMA

                                            • UNDROP SCHEMA

                                            • USE SCHEMA

                                            • SHOW SCHEMAS

                                            Share¶

                                            • CREATE SHARE

                                            • ALTER SHARE

                                            • DESCRIBE SHARE

                                            • DROP SHARE

                                            • SHOW SHARES

                                            Was this page helpful?

                                            Visit Snowflake
                                            Join the conversation
                                            Develop with Snowflake
                                            Share your feedback
                                            Read the latest on our blog
                                            Get your own certification
                                            Privacy NoticeSite TermsCookies Settings© 2025 Snowflake, Inc. All Rights Reserved.
                                            1. Database
                                            2. Schema
                                            3. Share
                                            Language: English
                                            • English
                                            • Français
                                            • Deutsch
                                            • 日本語
                                            • 한국어
                                            • Português