How to check if a column has not null constraint?

Question

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..

Answer 1

SELECT  *
FROM    INFORMATION_SCHEMA.COLUMNS

This query will show 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'

COLUMNS (Transact-SQL)

Answer 2

Something like

SELECT o.name AS tab, c.name AS col, c.is_nullable 
FROM sys.objects o
INNER JOIN sys.columns c ON c.object_id = o.object_id
WHERE o.name like '%yourtable%' and type = 'U'

See sys.columns and sys.objects