Null and FK

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
Null and FK

SQL Server 2005 General discussion of SQL Server *2005* version only.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

March 28th, 2007, 09:13 AM

scandalous scandalous is offline

scandalous is offline

Friend of Wrox

Join Date: Jan 2007

Posts: 109

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via AIM to scandalous

Send a message via MSN to scandalous

Default

Null and FK

In what cases should the Null check box in a field property be checked or unchecked? Especially when its a FK?

Old

March 28th, 2007, 03:40 PM

agossage

agossage is offline

Authorized User

Join Date: Dec 2006

Posts: 57

Thanks: 0

Thanked 0 Times in 0 Posts

Default

If a valid value for the column is NULL, then set NULL to checked to allow for NULLs.
If the only valid values for the column are keyed in another table, then set NULL to unchecked to disallow NULLs.

HTH

Adam Gossage
Lake Wylie, SC, USA

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
getting null value	ketAccess	Access VBA	4	March 13th, 2007 07:11 AM
setting the value of FK	csharpa	SQL Server 2005	1	March 8th, 2007 01:50 PM
setting the value of FK	csharpa	.NET Framework 2.0	0	February 28th, 2007 10:53 PM
setting the value of FK	csharpa	ADO.NET	0	February 28th, 2007 10:50 PM
How to set Not Null constraint to Null Columns	arasu	Oracle	1	August 22nd, 2005 10:09 AM