Skip to main content
Get StartedConsole GuideWork With DataRelease NotesReference
Resources
VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache Doris versionsVersion mapping

SHOW DATA TYPES

Description​

This statement is used to view all supported data types.

Syntax​

SHOW DATA TYPES;

Return Value​

Column NameDescription
TypeNameName of the type
SizeSize in bytes

Access Control Requirements​

The user executing this SQL command does not require specific privileges.

Example​

  • Display all supported data types

    SHOW DATA TYPES;
    +----------------+------+
    | TypeName       | Size |
    +----------------+------+
    | AGG_STATE      | 16   |
    | ARRAY          | 32   |
    | BIGINT         | 8    |
    | BITMAP         | 16   |
    | BOOLEAN        | 1    |
    | CHAR           | 16   |
    | DATE           | 16   |
    | DATETIME       | 16   |
    | DATETIMEV2     | 8    |
    | DATEV2         | 4    |
    | DECIMAL128     | 16   |
    | DECIMAL32      | 4    |
    | DECIMAL64      | 8    |
    | DECIMALV2      | 16   |
    | DOUBLE         | 8    |
    | FLOAT          | 4    |
    | HLL            | 16   |
    | INT            | 4    |
    | IPV4           | 4    |
    | IPV6           | 16   |
    | JSON           | 16   |
    | LARGEINT       | 16   |
    | MAP            | 24   |
    | QUANTILE_STATE | 16   |
    | SMALLINT       | 2    |
    | STRING         | 16   |
    | TINYINT        | 1    |
    | VARCHAR        | 16   |
    +----------------+------+