SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT

FROM INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME = 'purdate'

AND TABLE_SCHEMA = 'oracall_dev';

MariaDB [oracall_dev]> SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT

    -> 

    -> FROM INFORMATION_SCHEMA.COLUMNS

    -> 

    -> WHERE COLUMN_NAME = 'purdate'

    -> 

    -> AND TABLE_SCHEMA = 'oracall_dev';

+------------------------+-------------+-----------+-------------+---------------------+

| TABLE_NAME             | COLUMN_NAME | DATA_TYPE | IS_NULLABLE | COLUMN_DEFAULT      |

+------------------------+-------------+-----------+-------------+---------------------+

| rx_nstore_digital_cart | purdate     | char      | NO          | NULL                |

| rx_ncart               | purdate     | char      | YES         | current_timestamp() |

| rx_nstore_cart         | purdate     | char      | NO          | NULL                |

+------------------------+-------------+-----------+-------------+---------------------+