No announcements
Found 3807360 threads
-
0 VotesDeliberately orphaning records - but =The relationship could not be changed because one or more of the foreign-key properties is non-nullable
You can do this in the properties of the foreign key in SQL Managemnt Studio.Answered | 4 Replies | 2368 Views | Created by noJedi - Wednesday, August 1, 2012 5:17 AM | Last reply by noJedi - Thursday, August 2, 2012 3:42 AM
-
3 Votes
A foreign key accepting null values
A nullable foreign key column is of non identifying relationship type.Answered | 14 Replies | 1948 Views | Created by G Srikar Reddy - Friday, May 23, 2014 11:18 AM | Last reply by Saeid Hasani - Friday, June 6, 2014 10:19 PM -
1 Votes
A foreign key value cannot be inserted because a corresponding primary key value does not exist. [ Foreign key constraint name =
Table Alpha has a foreign key relation with Table Bravo.Answered | 2 Replies | 17880 Views | Created by Prajith Eringathody - Tuesday, June 8, 2010 8:41 PM | Last reply by Craig PDX - Tuesday, October 9, 2012 4:06 PM -
0 Votes
foreign key end of a relationship objectstateentry
When you delete records or change primary key values in a primary table, Microsoft Access makes necessary changes to related tables to preserve ...Answered | 1 Replies | 3775 Views | Created by voilbak - Tuesday, March 8, 2011 8:35 PM | Last reply by Jackie-Sun - Thursday, March 10, 2011 7:30 AM -
0 Votes
Foreign key and relationship in SSDS
While this works when you always have code between the client and the SSDS data, they fail in cases where the SSDS data will be accessed directly.Answered | 6 Replies | 9316 Views | Created by c.c.chai - Saturday, June 7, 2008 8:51 AM | Last reply by Mike Amundsen - Saturday, June 28, 2008 12:09 AM -
0 Votes
How do I set the property to show the foreign key relationship on a column
Hi dawits, You can edit the Foreign Key relationship on the list of Keys item under the table.Answered | 5 Replies | 6503 Views | Created by witdaj - Tuesday, April 26, 2011 5:21 AM | Last reply by Stephanie Lv - Friday, April 29, 2011 6:35 AM -
0 Votes
Problem setting Foreign Key Constraint
What would be causing this error, is considering only those tables which have foreign keys constraints that have either the ON UPDATE CASCADE or ON UPDATE SET ...Answered | 7 Replies | 3904 Views | Created by Ryan0827 - Friday, June 22, 2012 12:43 PM | Last reply by Tom Cooper - Monday, June 25, 2012 2:37 AM -
0 Votes
Foreign key
CREATE TABLE CreditCard( CreditCardID int IDENTITY(1,1) PRIMARY KEY, -- Surrogate key CustomerID int REFERENCES ...Answered | 6 Replies | 4466 Views | Created by ceewee2000 - Thursday, September 24, 2009 9:35 AM | Last reply by Kundan Sinha - Thursday, September 24, 2009 11:59 AM -
0 Votes
Issue creating Foreign Key Relationship
ALTER TABLE UserDates ADD CONSTRAINT fk_UserDates_UserTable FOREIGN KEY(Username) ...Answered | 6 Replies | 1452 Views | Created by obrienkev - Friday, February 15, 2013 11:35 AM | Last reply by Kalman Toth - Sunday, February 17, 2013 3:28 PM -
0 Votes
Primary Key and Foreign Key
First of all simply put, Foreign Key is a means to indicate relationship between two tables i.e a way to specify that the contents of a particular column corresponds to a ...Answered | 4 Replies | 1001 Views | Created by Ronald Rex - Sunday, September 9, 2018 12:21 AM | Last reply by Ronald Rex - Sunday, September 9, 2018 7:02 PM -
0 Votes
Foreign key to composite key
I made the relationship between Course table and Semester table and there is a composite key between them.Answered | 8 Replies | 11135 Views | Created by jinzuya - Monday, November 15, 2010 9:51 PM | Last reply by afrodita_ust - Thursday, November 17, 2011 2:54 PM -
7 Votes
Foreign key can't save null
What you posted does not contain constraints (primary or foreign key).Answered | 6 Replies | 1355 Views | Created by JerinBaby - Tuesday, July 19, 2016 9:55 AM | Last reply by scott_morris-ga - Tuesday, July 19, 2016 2:59 PM -
2 Votes
EF CTP4: Foreign key relationships not coming out as expected
Is it because it has already figured out there's a relationship between those two based on the navigation properties?Answered | 4 Replies | 6659 Views | Created by cedubose - Monday, September 13, 2010 9:53 PM | Last reply by Rowan Miller - Monday, September 27, 2010 5:14 PM -
0 Votes
Foreign Key Relationship ignored - Why?
But I can't just add relationship manually because I have 25 tables to link...Answered | 4 Replies | 4555 Views | Created by Andre111123 - Saturday, December 18, 2010 1:06 AM | Last reply by Jackie-Sun - Tuesday, June 18, 2013 1:58 AM -
1 Votes
Primary key and Foreign Key
See this illustration create table t ( id int identity(1,1) not null primary key, val varchar(100) ) create table t2 ( id int not ...Answered | 4 Replies | 1297 Views | Created by smtaqi - Saturday, August 30, 2014 8:08 AM | Last reply by Visakh16 - Saturday, August 30, 2014 6:59 PM -
0 Votes
Column is both a Primary Key and Foreign Key
The relational model does not require a FOREIGN KEY column to disallow nulls.Answered | 4 Replies | 17280 Views | Created by Olimicus03 - Friday, November 5, 2010 7:14 PM | Last reply by J Alverson - Friday, November 26, 2010 5:48 AM -
3 Votes
Including Null/Empty option in Foreign key drowpdown
It can also bite you in the rear end when you least expect it.Answered | 6 Replies | 2358 Views | Created by rdavison - Tuesday, September 6, 2011 1:53 AM | Last reply by Yann Duran - Thursday, September 8, 2011 12:35 AM -
0 Votes
NULL Values in Foreign Keys?
But so can a NULLable foreign key.Answered | 11 Replies | 13546 Views | Created by Boorat - Monday, January 23, 2012 4:14 PM | Last reply by Gert-Jan Strik - Sunday, January 29, 2012 2:01 PM -
0 Votes
What is the advantage of Foreign keys in database
Yes, you can have a nullable column (assuming what you meant is like in the following example) CREATE TABLE A(id INT NOT NULL PRIMARY KEY); GO CREATE ...Answered | 6 Replies | 745 Views | Created by Mou_kolkata - Wednesday, April 22, 2015 12:28 PM | Last reply by JamesKJ - Wednesday, April 22, 2015 1:36 PM -
1 Votes
Does a foreign key have to be a primary key
Link is created between two tables when the column or columns that hold the primary key value for one table are referenced by the column or columns in another ...Answered | 9 Replies | 1905 Views | Created by Divideby - Wednesday, July 30, 2014 10:43 AM | Last reply by Ahsan Kabir - Thursday, August 7, 2014 6:12 AM - Items 1 to 20 of 3807360 Next ›
No announcements
