dbrowse

Index Metadata

This node is descriptive, functional and terminating.
[definitions]

Query Path

Interactive Path

Synopsis

This is a detailed view of all metadata for the selected index in the active table from the current database.

Node/View

[skip to the dbrowse Navigation information]

SQL Statement

Note: MySQL does not support a LIKE clause for the show keys SQL statement as it does with many others. I should point out that for the vast majority of the views you get while browsing a database with this application, the results you see above will always include in the XHTML table header the exact query I issued to the MySQL server to retrieve these results. However, in this case I cannot request this metadata for a single index. I have to select from the list of all keys returned in order to focus on the one I want to display in this node. For an overview and additional information, visit the MySQL Reference Manual section on Show Statement Syntax.

Recall from the previous node that the MySQL statements show keys and show index are equivalent.

Description of Results

Since the fields shown in the top portion of the results in this node have already been documented in the previous view, I will not reiterate them here. For detailed documentation regarding the information displayed on this page, visit the MySQL Reference Manual section on Show Index. The highlighted fields in this view are described below, some of which have links to more specific sections of the manual.

A Field Name rendered in blue indicates this index is treated as a Foreign Key by some other table in this database. Selecting the key will take you to the structural view for that table.

MySQL Terms

Column Allowed Null Value

Indicates whether the field for this index may contain a Null value.

Collation or Sort Order

The column sorting order for this index: Ascending, Descending, or Unsorted. (descending keys are as yet unimplemented).

Packed Key Method

How the key is packed, or Not Packed (Null).

Server Comments

Reserved by the MySQL system for notations regarding the index.

Navigation

This is a terminating view in one query path for the active database. You may use your Web browser to return to the previous view and select another path, or try the interactive interface.