SHOW COLUMNS displays information about the columns in a given list. The SHOW FIELDS command is a synonym for SHOW COLUMNS.
Syntax
SHOW {COLUMNS | FIELDS} FROM list_name [.{view_name | content_type_name | ALL | ATTACHMENTS}];
Example: to show columns of list Employees:
SHOW COLUMNS FROM Employees