To get SQL to explain a table showing all the columns and their datatypes you can use the following code: EXPLAIN tableName; For example EXPLAIN products … Original source