DOCUMENTATION
/
Language
English
Français
Deutsch
日本語
한국어
Português
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
          • Business continuity & disaster recovery
          • Sessions
          • Transactions
          • Virtual warehouses & resource monitors
          • Databases, schemas, & shares
              1. Database
              2. CREATE DATABASE
              3. ALTER DATABASE
              4. 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
                                                • Workspaces
                                                • SHOW WORKSPACES
                                              • Tables, views, sequences, and types
                                              • Functions, procedures, & scripting
                                              • Streams & tasks
                                              • DCM Projects
                                              • dbt Projects on Snowflake
                                              • Classes & instances
                                              • Machine learning
                                              • Cortex
                                              • Listings
                                              • Openflow data plane integration
                                              • Organization profiles
                                              • Security
                                              • Data Governance
                                              • Privacy
                                              • Data loading & unloading
                                              • File staging
                                              • Storage lifecycle policies
                                              • Git
                                              • Alerts
                                              • Native Apps Framework
                                              • Streamlit
                                              • Notebook
                                              • Snowpark Container Services
                                              • Snowflake Postgres
                                          • 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

                                            • ALTER DATABASE (catalog-linked)

                                            • 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© 2026 Snowflake, Inc. All Rights Reserved.

                                            Alternative interfaces

                                            Snowflake Python APIs

                                            Snowflake REST APIs

                                            Snowflake CLI

                                            1. Database
                                            2. Schema
                                            3. Share