DESCRIBE <object>¶

Syntax¶

DESC[RIBE] <object_type> <object_name>

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

Session/Query Operations:

• DESCRIBE RESULT

• DESCRIBE TRANSACTION

Account Objects:

• DESCRIBE DATABASE

• DESCRIBE INTEGRATION

• DESCRIBE NETWORK POLICY

• DESCRIBE SHARE

• DESCRIBE USER

• DESCRIBE WAREHOUSE

Database Objects:

• DESCRIBE ALERT

• DESCRIBE EVENT TABLE

• DESCRIBE EXTERNAL TABLE

• DESCRIBE FILE FORMAT

• DESCRIBE FUNCTION

• DESCRIBE MASKING POLICY

• DESCRIBE MATERIALIZED VIEW

• DESCRIBE PASSWORD POLICY

• DESCRIBE PIPE

• DESCRIBE PROCEDURE

• DESCRIBE ROW ACCESS POLICY

• DESCRIBE SCHEMA

• DESCRIBE SECRET

• DESCRIBE SEQUENCE

• DESCRIBE SESSION POLICY

• DESCRIBE STAGE

• 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.