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 |