Documentation Home
MySQL 9.5 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.4Mb
PDF (A4) - 41.5Mb
Man Pages (TGZ) - 272.3Kb
Man Pages (Zip) - 378.2Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


25.6.15.23 The ndbinfo dictionary_columns Table

The table providesNDB dictionary information about columns ofNDB tables.dictionary_columns has the columns listed here (with brief descriptions):

  • table_id

    ID of the table containing the column

  • column_id

    The column's unique ID

  • name

    Name of the column

  • column_type

    Data type of the column from the NDB API; seeColumn::Type, for possible values

  • default_value

    The column's default value, if any

  • nullable

    Either ofNULL orNOT NULL

  • array_type

    The column's internal attribute storage format; one ofFIXED,SHORT_VAR, orMEDIUM_VAR; for more information, seeColumn::ArrayType, in the NDB API documentation

  • storage_type

    Type of storage used by the table; either ofMEMORY orDISK

  • primary_key

    1 if this is a primary key column, otherwise0

  • partition_key

    1 if this is a partitioning key column, otherwise0

  • dynamic

    1 if the column is dynamic, otherwise0

  • auto_inc

    1 if this is anAUTO_INCREMENT column, otherwise0

You can obtain information about all of the columns in a given table by joiningdictionary_columns with thedictionary_tables table, like this:

SELECT dc.*  FROM dictionary_columns dcJOIN dictionary_tables dt  ON dc.table_id=dt.table_idWHERE dt.table_name='t1'  AND dt.database_name='mydb';
Note

Blob columns are not shown in this table. This is a known issue.