Why I am seeing NULL value in a table where the schema defines as NOT NULL field?
Are you sure those "empty" cells are set to NULL?

It could be that they have inserted empty strings to get past the Not Null restriction. Code like this will bypass a Not Null setting:

INSERT INTO &lt;table&gt; (Pat_LNAME, Pat FmName, Pat_email) values ('', ' ', '  ');


Notice, in the LNAME field, I pass an empty string '' (two single quote marks). In the second, I pass in a space, ' '. In the third I pass two spaces '  '. All three will get past a NOT NULL rule.

But this code WOULD fail:

INSERT INTO &lt;table&gt; (Pat_LNAME, Pat FmName, Pat_email) values (null, ' ', '  ');


Or any insert that didn't have a Pat_lname field included. 

In SQL Server Management Studio, your view would show you Null columns like this:



Note the yellow background and the word NULL to show there's no data.

Remember, NULL does not equal empty string.