DESCRIBE

Purpose

Use the DESCRIBE statement to display information about columns in a given table.

Syntax

Diagram

describe

Keywords and Parameters

schemaName

This is an identifier that specifies the name of the schema that contains the table to be displayed. If not specified, the default (current) schema is used.

tableName

This is an identifier that specifies the name of the table to be displayed.

Examples

Displaying Columns in a Table

The following is an example of displaying information about columns in the table order_products.

DESCRIBE instacart.order_products;