DESCRIBE

The DESCRIBE TABLE command is used to provide high-level information regarding the overall column properties of an existing dataset.

Spice DESCRIBE supports all filesystem source types and relies upon a user’s existing privileges to access and describe a table or view.

Syntax

Parameters

  • <table_name> String The name of an existing user-defined table.

Examples

DESCRIBE TABLE syntax.
DESCRIBE TABLE table_name;
Describing a table
DESCRIBE TABLE eth.blocks;

Once a table or view has been queried, the Spice UI displays the following:

  • Column headers indicating the type of information being described.

  • Rows describing each table column.

  • Data types, properties, policies, and other associated attributes

COLUMN_NAMEDATA_TYPEIS_NULLABLENUMERIC_PRECISIONNUMERIC_SCALEEXTENDED_PROPERTIESMASKING_POLICY

number

BIGINT

YES

64

0

[]

[]

hash

CHARACTER VARYING

YES

NULL

NULL

[]

[]

parent_hash

CHARACTER VARYING

YES

NULL

NULL

[]

[]

nonce

CHARACTER VARYING

YES

NULL

NULL

[]

[]

sha3_uncles

CHARACTER VARYING

YES

NULL

NULL

[]

[]

logs_bloom

CHARACTER VARYING

YES

NULL

NULL

[]

[]

The cells containing a β€˜[]’ indicate β€œempty” values.

Last updated