DESC|DESCRIBE TABLE [db.]table [INTO OUTFILE filename] [FORMAT format]

Returns the following String type columns:

  • name — Column name.
  • type— Column type.
  • default_type — Clause that is used in default expression (DEFAULT, MATERIALIZED or ALIAS). Column contains an empty string, if the default expression isn’t specified.
  • default_expression — Value specified in the DEFAULT clause.
  • comment_expression — Comment text.

Nested data structures are output in “expanded” format. Each column is shown separately, with the name after a dot.

Rating: 2.4 - 38 votes

Was this content helpful?