No announcements
Found 362712 threads
-
0 VotesPrimary Key and Foreign Key
For example, suppose you have a Products table with primary key ProductID and an Orders table with primary key OrderID and each line item on the ...Answered | 4 Replies | 1216 Views | Created by Ronald Rex - Sunday, September 9, 2018 12:21 AM | Last reply by Ronald Rex - Sunday, September 9, 2018 7:02 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 ...Answered | 4 Replies | 1531 Views | Created by smtaqi - Saturday, August 30, 2014 8:08 AM | Last reply by Visakh16 - Saturday, August 30, 2014 6:59 PM -
3 Votes
Composite Primary key and Foreign key
11 as Foreign Key value or "Taylor Swift"?Answered | 18 Replies | 61035 Views | Created by mahima - Friday, February 8, 2008 3:51 PM | Last reply by Kalman Toth - Sunday, April 10, 2011 8:52 PM -
2 Votes
primary foreign key referencing
This means that a primary key can be a primary and a foreign key at the same time in the same table?Answered | 9 Replies | 9769 Views | Created by N.Afache - Friday, October 21, 2011 11:51 AM | Last reply by J Alverson - Sunday, October 30, 2011 7:32 AM -
1 Votes
Does a foreign key have to be a primary key
4.Purpose of a FOREIGN KEY constraint is to control the data that can be stored in the foreign key table, it also controls changes to data in ...Answered | 9 Replies | 2116 Views | Created by Divideby - Wednesday, July 30, 2014 10:43 AM | Last reply by Ahsan Kabir - Thursday, August 7, 2014 6:12 AM -
1 Votes
Primary, Foreign Key
> For A, it has 1 primary key and B has a foreign key which maps to table > A primary key.Answered | 2 Replies | 1471 Views | Created by Wen Hao Mui - Thursday, June 7, 2012 3:00 PM | Last reply by darnold924 - Thursday, June 7, 2012 3:36 PM -
2 Votes
Foreign key references a two column primary key
There is absolutely no workaround to have a foreign key with one column referencing to a primary key of two columns?Answered | 13 Replies | 21803 Views | Created by pyram07 - Thursday, June 14, 2012 1:17 PM | Last reply by pyram07 - Thursday, June 14, 2012 6:18 PM -
3 Votes
referencing foreign keys from composite primary keys
Composite PRIMARY KEY in this instance is not a good way to go.Answered | 4 Replies | 4156 Views | Created by slickk_F - Monday, February 11, 2013 11:42 AM | Last reply by Kalman Toth - Wednesday, February 13, 2013 7:53 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 | 17489 Views | Created by Olimicus03 - Friday, November 5, 2010 7:14 PM | Last reply by J Alverson - Friday, November 26, 2010 5:48 AM -
0 Votes
primary and foreign key constraints
I am working to add each of the tables to the database, with their primary and foreign keys where I believe they are applicable.Answered | 7 Replies | 8305 Views | Created by hfinny - Wednesday, May 5, 2010 11:20 PM | Last reply by Louis Davidson - Thursday, May 6, 2010 8:46 PM -
1 Votes
primary and foreign key question
Hi, It is mandatory for the primary key and the foreign key to use the same data type.Answered | 6 Replies | 1622 Views | Created by bestrongself - Sunday, February 16, 2014 12:21 AM | Last reply by Alankar Chakravorty - Sunday, February 16, 2014 6:44 PM -
2 Votes
Need a Query that Returns Primary Keys, Foreign Keys, Foreign Key References
.'+ TC.TABLE_NAME AS PRIMARYKEYTABLE ,TC.CONSTRAINT_NAME AS PRIMARYKEY ,CU.COLUMN_NAME as [Primary Column ...Answered | 4 Replies | 2469 Views | Created by cdun2 - Tuesday, December 11, 2012 11:28 PM | Last reply by cdun2 - Wednesday, December 12, 2012 8:01 PM -
0 Votes
Foreign Key on a column which is not Primary Key of the table
Check this link http://msdn.microsoft.com/en-us/library/ms189049.aspx Limitations and Restrictions A foreign key constraint ...Answered | 3 Replies | 1264 Views | Created by SqlShan - Friday, August 1, 2014 3:37 PM | Last reply by --CELKO-- - Friday, August 1, 2014 10:06 PM -
0 Votes
Entity Framework - Primary Key and Foreign Key Namess
However EF doesn't support foreign keys that refer to unique indexes, and not the primary key.Answered | 1 Replies | 1617 Views | Created by Natron61 - Monday, December 30, 2013 3:35 PM | Last reply by davidbaxterbrowne - Monday, December 30, 2013 3:53 PM -
1 Votes
2 foreign keys points to the same primary key
hi there, Try to alter your table to add foreign keys to your table "users", check below alter scripts: alter table users add ...Answered | 3 Replies | 3911 Views | Created by ola salem - Monday, June 28, 2010 11:43 PM | Last reply by ola salem - Tuesday, June 29, 2010 10:40 AM -
0 Votes
Identify Column as Primary Key with Foreign Keys Referencing it
I guess you would have to ensure that when a record is added to the Primary, it is also added to the Foreign Key table?Answered | 3 Replies | 5100 Views | Created by Patrick_Cox - Monday, December 9, 2019 12:28 PM | Last reply by Guoxiong Yuan - Monday, December 9, 2019 2:53 PM -
1 Votes
TSQL For foreign key and Primary key
Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are.Answered | 4 Replies | 1923 Views | Created by nnmmss - Saturday, September 28, 2013 8:03 AM | Last reply by --CELKO-- - Saturday, September 28, 2013 4:53 PM -
0 Votes
Update primary and foreign keys
table t2 add constraint fk_t1 foreign key (col1)Answered | 2 Replies | 5558 Views | Created by Funflex - Friday, August 6, 2010 6:28 AM | Last reply by RohitDBA - Friday, August 6, 2010 1:13 PM -
0 Votes
delete foreign keys against a single primary key
i also want to delete from all the entries. e.g: if a primary key's column entry deleted then all foreing key entries should also be deleted. . i want to do it ...Answered | 2 Replies | 4061 Views | Created by Mehmood Ahmed - Wednesday, April 14, 2010 7:35 PM | Last reply by Kalman Toth - Tuesday, April 20, 2010 1:17 AM -
0 Votes
Foreign key to composite key
Also the question is the primary key.Answered | 8 Replies | 11378 Views | Created by jinzuya - Monday, November 15, 2010 9:51 PM | Last reply by afrodita_ust - Thursday, November 17, 2011 2:54 PM - Items 1 to 20 of 362712 Next ›
No announcements
