NULLABLE Columns
Posted: Sun Sep 29, 2024 10:23 am
Code: Select all
SELECT *
FROM information_schema.COLUMNS
WHERE IS_NULLABLE = 'YES'
and TABLE_NAME like 'BMC%'
and TABLE_NAME NOT LIKE '%ARCHIVE'CMDB professionals helping clients to skate the event horizon of a black hole (where your data disappears). Keeping you ahead of the game.
http://blackholesurfer.com/phpBB3/
Code: Select all
SELECT *
FROM information_schema.COLUMNS
WHERE IS_NULLABLE = 'YES'
and TABLE_NAME like 'BMC%'
and TABLE_NAME NOT LIKE '%ARCHIVE'