DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
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
                • 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
                                                • Classes & instances
                                                • Machine learning
                                                • Cortex Search Service
                                                • Listings
                                                • Organization profiles
                                                • Security
                                                • Data Governance
                                                • Privacy
                                                • Data loading & unloading
                                                • File staging
                                                • 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

                                              • 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 Terms© 2025 Snowflake, Inc. All Rights Reserved.
                                              1. Database
                                              2. Schema
                                              3. Share
                                              Language: English
                                              • English
                                              • Français
                                              • Deutsch
                                              • 日本語
                                              • 한국어
                                              • Português