Question

Error In SQL SERVER DataBase

VARCHAR, NULL values, Primary keys, Database programming, Visual Studio 2008, Visual Studio, SQL Server errors

am trying to insert four varchar(50) values in a table which is with a primarykey column id_number. i didnt check : "True" to the null field . so it should not allow null values in table. but while am trying . it allows null values. including primary key column. how is possible ?


pls help me.

i am using this database with visual studio 2008

If you Primary Key column allows null, then it's not setup as a primary key as primary key columns can not allow null values in them.

If you check the box in the UI it tells to column to allow nulls.