[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

Referential Integrity

I have created a link between tables by foreign key. I may have to leave this foreign key value blank ( as there might not be a valid entry for this field) . At the moment referential integrity is forcing me to not leave this foreign key value blank. Because I have a foreign key declared does this mean that I have to enter a value here. ??????????
0
calis
Asked:
calis
1 Solution
 
kdimmockCommented:
Blank?  Try NULL (the reserved word, not a string!).  Make sure the column is "nullable".  It should work.

insert into table1 values('A',Null)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now