Minggu, 06 Maret 2011
Can an identity column be nullable?
One of my friends asked me whether an identity column can be NULL.When he was viewing the table script he noticed that SQL Server adds NOT NULL constraint to identity columns automatically eventhough he did not speficy it when creating a table Consider the following table scriptcreate table test(id int identity(1,1), name varchar(1000))Now Generate the script of the table from Management Studio.
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar