Lists columns and their properties for a specified table. Returns <table_name>, <column_name>, <data_type>, and nullable (TRUE if nullable, FALSE if not) for each column.

Syntax

SHOW COLUMNS <table>;

Parameters

ParameterDescription
<table>The name of the table to be analyzed.

Example

The following example highlights all of the columns from the tournaments table:

SHOW COLUMNS tournaments;
table_namecolumn_namedata_typenullable
tournamentsenddatetimeTIMESTAMPFALSE
tournamentsgameidINTEGERFALSE
tournamentsnameTEXTFALSE
tournamentsrulesdefinitionTEXTFALSE
tournamentsSOURCE_FILE_NAMETEXTFALSE
tournamentsSOURCE_FILE_TIMESTAMPTIMESTAMPFALSE
tournamentsstartdatetimeTIMESTAMPFALSE
tournamentstotalprizedollarsINTEGERFALSE
tournamentstournamentidINTEGERFALSE