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://www.blackholesurfer.com/phpBB3/
http://www.blackholesurfer.com/phpBB3/viewtopic.php?f=24&t=127
Code: Select all
SELECT *
FROM information_schema.COLUMNS
WHERE IS_NULLABLE = 'YES'
and TABLE_NAME like 'BMC%'
and TABLE_NAME NOT LIKE '%ARCHIVE'