Code: Select all
SELECT *
FROM information_schema.COLUMNS
WHERE IS_NULLABLE = 'YES'
and TABLE_NAME like 'BMC%'
and TABLE_NAME NOT LIKE '%ARCHIVE'NULLABLE Columns
-
hudatolah
- Site Admin
- Posts: 152
- Joined: Thu Apr 04, 2013 8:10 pm
- Are You a Headhunter?: Affirmative
- Surfer?: Yes
NULLABLE Columns
The Blackholesurfer. My surfboard has teeth.