Link Search Menu Expand Document

SHOW COLUMNS

Lists columns and their properties for a specified table. Returns <table_name>, <column_name>, <data_type>, and nullable (1 if nullable, 0 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