Find the default values of the columns and the column names


(SELECT column_name,column_default
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'table name')