1

Is it possible to have nulls in Foreign keys in any ANSI SQL database?

pavanred
  • 12,717
  • 14
  • 53
  • 59
  • 1
    Yes. Check out Vincent's answer on this thread http://stackoverflow.com/questions/767657/how-do-i-create-unique-constraint-that-also-allows-nulls-in-sql-server – Jagmag Oct 30 '10 at 06:33

1 Answers1

4

sure, in all databases it's possible. unless the field is declared as NOT NULL.

heximal
  • 10,327
  • 5
  • 46
  • 69