I think I’ve solved this myself by just using:

select * from INFORMATION_SCHEMA.columns

I can then filter on the Column Default to show the records that aren’t NULL, and then subsequently filter on IS Nullable = Yes.