Knowledge Base · Contact · Login SHOW COLUMNS displays information about the columns in a given table. based on a CREATE TABLE statement, note that MariaDB sometimes changes data types when you create or alter a table. The Null field contains YES if NULL values can be stored in the column, NO if not..