Answers for "show columns from table where"

show table columns

-- MySQL
DESCRIBE tableName;
SHOW COLUMNS FROM tableName;

-- SQLite3
.schema tableName

Posted by: Guest on May-11-2021

SHOW COLUMNS Statement

SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS}
    {FROM | IN} tbl_name
    [{FROM | IN} db_name]
    [LIKE 'pattern' | WHERE expr]

Posted by: Guest on October-18-2021

Code answers related to "show columns from table where"