No announcements
Found 859589 threads
-
0 Votes
Primary Key and Foreign Key
It doesn't seem well written for explanatory purposes.Answered | 4 Replies | 1138 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
Conditional Foreign Key?
KEY (PurposeID, PurposeType) REFERENCES dbo.Purpose(PurposeID, [Type]), CONSTRAINT FK_Hearing_Outcome FOREIGN KEY (OutcomeID, OutcomeType) REFERENCES ...Answered | 13 Replies | 16351 Views | Created by DesertDude - Wednesday, April 7, 2010 8:52 PM | Last reply by Hunchback - Tuesday, April 13, 2010 6:18 PM -
1 Votes
How to update foreign key...
Hi Umar, The FOREIGN KEY Constraint is used to ensure the referential integrity of data in one table to match values in another table.Answered | 2 Replies | 3497 Views | Created by Umar Farooq Shafi - Thursday, August 22, 2019 4:46 PM | Last reply by Umar Farooq Shafi - Friday, August 23, 2019 7:00 AM -
1 Votes
Does a foreign key have to be a primary key
This column becomes a foreign key in the second table.Answered | 9 Replies | 2043 Views | Created by Divideby - Wednesday, July 30, 2014 10:43 AM | Last reply by Ahsan Kabir - Thursday, August 7, 2014 6:12 AM -
0 Votes
Foreign Key NOT referencing PK
It makes sense, I've just never seen a foreign key reference anything but the primary key to enforce RI.Answered | 4 Replies | 7312 Views | Created by KitGreen - Monday, September 18, 2006 7:38 PM | Last reply by KitGreen - Wednesday, September 27, 2006 5:23 AM -
0 Votes
Foreign key to composite key
Then add foreign key (ManufactureId and ProductId) referencing the product table and a foreign key OrderNo referencing the order table.Answered | 8 Replies | 11287 Views | Created by jinzuya - Monday, November 15, 2010 9:51 PM | Last reply by afrodita_ust - Thursday, November 17, 2011 2:54 PM -
0 Votes
Foreign key
CREATE TABLE CreditCard( CreditCardID int IDENTITY(1,1) PRIMARY KEY, -- Surrogate key CustomerID int REFERENCES ...Answered | 6 Replies | 4584 Views | Created by ceewee2000 - Thursday, September 24, 2009 9:35 AM | Last reply by Kundan Sinha - Thursday, September 24, 2009 11:59 AM -
4 Votes
Update foreign key column
If you ENABLE the UPDATE CASCADE on your relationship, it will allow you to update the Foreign keys.Answered | 9 Replies | 37001 Views | Created by Ryan X - Tuesday, April 5, 2011 9:16 PM | Last reply by Arbi Baghdanian - Wednesday, April 6, 2011 12:48 AM -
0 Votes
Foreign Keys
5. add the tables you created 6. drag the pk from the parent to the foreign key colum of the child 7. save the ...Answered | 1 Replies | 6899 Views | Created by crazyabtdotnet - Wednesday, October 11, 2006 3:38 PM | Last reply by JoeyDj - Wednesday, October 11, 2006 9:40 PM -
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 null ...Answered | 4 Replies | 1442 Views | Created by smtaqi - Saturday, August 30, 2014 8:08 AM | Last reply by Visakh16 - Saturday, August 30, 2014 6:59 PM -
0 Votes
foreign key constraint error
The modeling tool complains saying "no parent item (key or index) has been found during foreign key creation".Answered | 5 Replies | 5939 Views | Created by Knot - Thursday, April 19, 2012 1:30 AM | Last reply by Knot - Sunday, April 22, 2012 1:29 AM -
0 Votes
Foreign Keys
It cannot be assumed that stores never move the location of categories, i.e. that the aisle is time-independently determined by the key of categories.Answered | 3 Replies | 525 Views | Created by Exceluser367 - Tuesday, October 6, 2015 8:29 PM | Last reply by Ken Sheridan - Wednesday, October 7, 2015 10:19 PM -
0 Votes
Column is both a Primary Key and Foreign Key
Your misunderstanding in in the rules for FOREIGN KEY constraints.Answered | 4 Replies | 17411 Views | Created by Olimicus03 - Friday, November 5, 2010 7:14 PM | Last reply by J Alverson - Friday, November 26, 2010 5:48 AM -
4 Votes
Advantages and disadvantages of using Foreign Keys
You should always include foreign keys.Answered | 8 Replies | 23997 Views | Created by Catherine0824 - Tuesday, September 13, 2011 10:57 AM | Last reply by Tomas Ludvik - Tuesday, August 4, 2015 10:51 AM -
0 Votes
Discussion of foreign key
When creating foreign key relationships, it's also a good idea to create a nonclustered index on the foreign key column if you're planning on using it frequently in ...Answered | 8 Replies | 6876 Views | Created by himengg - Wednesday, May 18, 2011 1:02 PM | Last reply by Mr. Wharty - Thursday, May 19, 2011 7:43 AM -
2 Votes
Is "Foreign Key" Keyword Necessary
There are two types of foreign key constraints.Answered | 11 Replies | 2898 Views | Created by Mike L (SQL Newb) - Thursday, February 7, 2013 8:32 PM | Last reply by Kalman Toth - Wednesday, February 13, 2013 8:51 AM -
3 Votes
what happens to foreign key
The data in the foreign key column will occupy as much space as the primary key it references to.Answered | 7 Replies | 7387 Views | Created by himengg - Wednesday, May 18, 2011 1:23 PM | Last reply by Stan210 - Thursday, May 19, 2011 12:52 PM -
3 Votes
Problem with writing a Foreign key
Please take look at this blog from Pinal Dave regarding "Primary Key", "Foreign Key", and "Default ...Answered | 5 Replies | 2692 Views | Created by FundamentalGan - Thursday, April 12, 2012 6:00 PM | Last reply by Arbi Baghdanian - Thursday, April 12, 2012 8:08 PM -
3 Votes
foreign key
The Foreign Key constraint DOES NOT show up under the Constraint Folder in SSMS Object explorer, it will show up under the "keys" folder for the table in question ...Answered | 5 Replies | 2548 Views | Created by tsql_new - Friday, November 30, 2012 3:41 PM | Last reply by Kalman Toth - Sunday, December 2, 2012 2:24 PM -
0 Votes
FOREIGN KEYS IN DISTINCT PUBLICATIONS
I created the foreign keys manually, the problem is when a snapshot is reinicialized, the foreign key is deleted automatically, even with the option to ...Answered | 5 Replies | 1021 Views | Created by carlosadrr - Monday, July 7, 2014 5:20 PM | Last reply by Hilary Cotter - Tuesday, July 8, 2014 3:45 PM - Items 1 to 20 of 859589 Next ›
No announcements