Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Identify a column is NULLABLE or not throughout the DB

Posted on 2013-06-07
2
238 Views
Last Modified: 2013-06-07
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.
0
Comment
Question by:Easwaran Paramasivam
2 Comments
 
LVL 8

Expert Comment

by:didnthaveaname
ID: 39228781
Should be able to accomplish this with a join of sys.columns (http://msdn.microsoft.com/en-us/library/ms176106.aspx) and sys.tables (http://msdn.microsoft.com/en-us/library/ms187406.aspx)
0
 
LVL 7

Accepted Solution

by:
Ross Turner earned 500 total points
ID: 39228813
Try This:

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

Open in new window

0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question