Dev Dev - 1 year ago 71
SQL Question

How to check if a column has not null constraint?

I am using SQL Server 2008 R2.

I have a table in which I have a column that have a not null constraint.

Now, what if I want to check if column has not null constraint defined or not for specific column?

Is there any query to find out it?

Thanks in advance..

Ric Ric
Answer Source

Show's all columns from all tables and a whole host of information on them. The column you would want is: IS_NULLABLE that can have the value 'YES' or 'NO'

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download