NULLABLE Columns

I decided to add this forum to keep track of solutions for DB related problems.
I have worked with some brilliant people in my life and the solutions to issues that are usually beyond something you can get at Jack in Box Jackson. They deserve historical marker. This is the historical marked on my map.
Pouzivej data base
Post Reply
hudatolah
Site Admin
Posts: 152
Joined: Thu Apr 04, 2013 8:10 pm
Are You a Headhunter?: Affirmative
Surfer?: Yes

NULLABLE Columns

Post by hudatolah » 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'
The Blackholesurfer. My surfboard has teeth.