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 |
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 |
+------------------------+-------------+-----------+-------------+---------------------+