Identify a column is NULLABLE or not throughout the DB

In my DB 'CreatedDtm' column is present in all the tables. I would like to know in all the tables the column is NOT NULLABLE. How to ensure that without scanning each table by table using TSQL?

Please do assist.
LVL 16
Easwaran ParamasivamAsked:
Who is Participating?
Ross TurnerConnect With a Mentor Management Information Support AnalystCommented:
Try This:

select,,sc.is_nullable from sys.columns sc
inner join sys.tables st on sc.object_id = st.object_id
where like 'CreatedDtm'

Open in new window

Should be able to accomplish this with a join of sys.columns ( and sys.tables (
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.