Get tables which using [DEFAULT CURRENT_TIMESTAMP] in mysql?

Question

Some tables are using DEFAULT CURRENT_TIMESTAMP for create_time field. I want to select all my tables which use DEFAULT CURRENT_TIMESTAMP] in mysql

Answer 1

Use,

SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_DEFAULT = 'CURRENT_TIMESTAMP'
-- AND TABLE_SCHEMA = DATABASE();