DOCUMENTATION
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Status
Ctrl+K

Reference

  1. Overview
    • SQL Command Reference
      • Query Syntax
        • Query Operators
          • General DDL
            • ALTER
              • COMMENT
                • CREATE
                  • DESCRIBE
                    • DROP
                      • UNDROP
                        • SHOW
                          • USE
                          • General DML
                            • All Commands (Alphabetical)
                              • Accounts
                                • Users, Roles, & Privileges
                                  • Integrations
                                    • Replication & Failover
                                      • Sessions
                                        • Transactions
                                          • Virtual Warehouses & Resource Monitors
                                            • Databases, Schemas, & Shares
                                              • Tables, Views, & Sequences
                                                • Functions, Procedures, & Scripting
                                                  • Streams & Tasks
                                                    • Classes & Instances
                                                      • Security
                                                        • Data Governance
                                                          • Data Loading & Unloading
                                                            • File Staging
                                                              • Alerts
                                                                • Native Apps Framework
                                                                  • Streamlit
                                                                  • Function Reference
                                                                    • Class Reference
                                                                      • Scripting Reference
                                                                        • General Reference
                                                                          • API Reference
                                                                            ReferenceSQL Command ReferenceGeneral DDLDESCRIBE

                                                                            DESCRIBE <object>¶

                                                                            Describes the details for the specified object.

                                                                            DESCRIBE can be abbreviated to DESC.

                                                                            See also:

                                                                            CREATE <object> , SHOW <objects>

                                                                            Syntax¶

                                                                            DESC[RIBE] <object_type> <object_name>
                                                                            
                                                                            Copy

                                                                            For specific syntax, usage notes, and examples, see:

                                                                            Session/Query Operations:

                                                                            • DESCRIBE RESULT

                                                                            • DESCRIBE TRANSACTION

                                                                            Account Objects:

                                                                            • DESCRIBE APPLICATION

                                                                            • DESCRIBE DATABASE

                                                                            • DESCRIBE INTEGRATION

                                                                            • DESCRIBE NETWORK POLICY

                                                                            • DESCRIBE SHARE

                                                                            • DESCRIBE USER

                                                                            • DESCRIBE WAREHOUSE

                                                                            Database Objects:

                                                                            • DESCRIBE ALERT

                                                                            • DESCRIBE DYNAMIC TABLE

                                                                            • DESCRIBE EVENT TABLE

                                                                            • DESCRIBE EXTERNAL TABLE

                                                                            • DESCRIBE FILE FORMAT

                                                                            • DESCRIBE FUNCTION

                                                                            • DESCRIBE MASKING POLICY

                                                                            • DESCRIBE MATERIALIZED VIEW

                                                                            • DESCRIBE NETWORK RULE

                                                                            • DESCRIBE PASSWORD POLICY

                                                                            • DESCRIBE PIPE

                                                                            • DESCRIBE PROCEDURE

                                                                            • DESCRIBE ROW ACCESS POLICY

                                                                            • DESCRIBE SCHEMA

                                                                            • DESCRIBE SECRET

                                                                            • DESCRIBE SEQUENCE

                                                                            • DESCRIBE SESSION POLICY

                                                                            • DESCRIBE STAGE

                                                                            • DESCRIBE STREAMLIT

                                                                            • DESCRIBE STREAM

                                                                            • DESCRIBE TABLE

                                                                            • DESCRIBE TASK

                                                                            • DESCRIBE VIEW

                                                                            Usage Notes¶

                                                                            • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

                                                                            Was this page helpful?

                                                                            Snowflake logo
                                                                            Visit Snowflake
                                                                            Have feedback? Let us know
                                                                            Join the conversation in our community
                                                                            Read the latest on our blog
                                                                            Develop with Snowflake
                                                                            Get your Snowflake certification
                                                                            Privacy NoticeSite Terms© 2023 Snowflake, Inc. All Rights Reserved.
                                                                            1. Syntax
                                                                            2. Usage Notes
                                                                            Language: English
                                                                            • English
                                                                            • Français
                                                                            • Deutsch
                                                                            • 日本語
                                                                            • 한국어
                                                                            • Português