SQL statement to get column type?

Question

Is there a SQL statement that can return the type of a column in a table?

Answer 1

In MySQL you can use:

describe table_name;

Or

show columns from table_name;