The following SQL DML Code allows you to retrieve 
the names of each column in a given table. 
'categories' is the table name used in this example.

SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH, 
NUMERIC_SCALE, NUMERIC_PRECISION, COLUMN_DEFAULT 
FROM information_schema.columns 
WHERE table_name = 'categories'