SHOW COLUMNS

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

Parameter Description
<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_name column_name data_type nullable
tournaments enddatetime TIMESTAMP FALSE
tournaments gameid INTEGER FALSE
tournaments name TEXT FALSE
tournaments rulesdefinition TEXT FALSE
tournaments SOURCE_FILE_NAME TEXT FALSE
tournaments SOURCE_FILE_TIMESTAMP TIMESTAMP FALSE
tournaments startdatetime TIMESTAMP FALSE
tournaments totalprizedollars INTEGER FALSE
tournaments tournamentid INTEGER FALSE