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

Accepted Answer

```
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)

How to check if a column has not null constraint?

Solution

Problem