To Get NULL Value Column Names

• sandeepivs

  SSC-Addicted

  Points: 494

  More actions

  July 21, 2011 at 1:39 am

  #254690

  Hi Friends,

  I have a table consists of around 200 Columns. I would like to find out the NULL Value Columns.

  How do I make it? Please let me know ASAP.

  Thanks In Advance,

  Sandeep IVS

  🙂

• ianT

  SSCrazy

  Points: 2956

  More actions

  July 21, 2011 at 2:07 am

  #1356183

  Hi

  How about:

  select * from INFORMATION_SCHEMA.columns

  where TABLE_NAME = 'T1' and IS_NULLABLE = 'YES'