<div>
Should be able to accomplish this with a join of sys.columns (<a href="http://msdn.microsoft.com/en-us/library/ms176106.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms176106.aspx</a>) and sys.tables (<a href="http://msdn.microsoft.com/en-us/library/ms187406.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms187406.aspx</a>)
</div>


Should be able to accomplish this with a join of sys.columns (http://msdn.microsoft.com/en-us/library/ms176106.aspx [http://msdn.microsoft.com/en-us/library/ms176106.aspx]) and sys.tables (http://msdn.microsoft.com/en-us/library/ms187406.aspx [http://msdn.microsoft.com/en-us/library/ms187406.aspx])

<div>
<div class="content wysiwyg-content">
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?<br />
<br />
<br />
Please do assist.
</div>
</div>


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.

Identify a column is NULLABLE or not throughout the DB

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.