List:General Discussion« Previous MessageNext Message »
From:Jeff Smelser Date:May 27 2004 2:24pm
Subject:Re: Foreign Key Constraints
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 27 May 2004 03:00 am, Martijn Tonies wrote:
> Why not? What's wrong with this:
>
> BORROWER
> BorrowerID
>
> BOOKS
> BookID
> BorrowerID (nullable)
>
> FK from Books.BorrowerID to Borrower.BorrowerID
>
> I haven't checked, but this _should_ be possible.
>
> With regards,

Its a foreign key, you can not null foreign keys.. Thats the problem.

- -- 
			  Practice safe sin.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAtfoTld4MRA3gEwYRApVcAJ9RNWF9qZrresicBlct3TP2fpEL1wCg3xIx
VER2P5MGzLgUqLRc7JZLFys=
=qVNw
-----END PGP SIGNATURE-----
Thread
Foreign Key Constraintskyuubi27 May
  • Re: Foreign Key ConstraintsJeff Smelser27 May
  • Re: Foreign Key ConstraintsColin Bull27 May
  • Re: Foreign Key ConstraintsRobert J Taylor27 May
  • Re: Foreign Key ConstraintsMartijn Tonies27 May
    • Re: Foreign Key ConstraintsJeff Smelser27 May
  • Re: Foreign Key ConstraintsMartijn Tonies27 May
  • Re: Foreign Key ConstraintsMartijn Tonies28 May
    • Re: Foreign Key ConstraintsJeff Smelser28 May
  • Re: Foreign Key ConstraintsMartijn Tonies28 May
    • Re: Foreign Key ConstraintsMichael Stassen28 May
      • Re: Foreign Key ConstraintsMichael Stassen28 May
  • Re: Foreign Key ConstraintsMartijn Tonies28 May
    • Re: Foreign Key ConstraintsJeff Smelser28 May
    • Re: Foreign Key ConstraintsJeff Smelser28 May
  • Re: Foreign Key ConstraintsMartijn Tonies28 May
Re: Foreign Key ConstraintsSGreen27 May