No announcements
Found 1740113 threads
-
0 VotesCreating Foreign keys
To qualify a foriegn key that key needs to be a primary or unique key column.Answered | 6 Replies | 4574 Views | Created by Sanam K M N - Monday, December 31, 2012 7:59 AM | Last reply by anuragsh - Wednesday, January 2, 2013 2:19 PM
-
0 Votes
Creating Foreign Key
While closing the diagram, the foreign key constraint(s) will be created automatically.Answered | 2 Replies | 4730 Views | Created by Milli_22 - Tuesday, January 18, 2011 3:42 PM | Last reply by K.Kuehne - Tuesday, January 18, 2011 4:34 PM -
0 Votes
error while creating foreign key
I want to create foreign key on Pkgsequencenumber which will reference Package.Packagenumber.Answered | 7 Replies | 3222 Views | Created by Incredible15 - Wednesday, June 2, 2010 3:00 PM | Last reply by Incredible15 - Wednesday, June 2, 2010 6:05 PM -
0 Votes
Unable to create foreign key
Actually now that I research I see that when a FK is created, the DB engine looks at both sides to check the data is properly related before creating the key.Answered | 6 Replies | 3830 Views | Created by QPR_JAY - Sunday, February 10, 2013 8:54 PM | Last reply by Dan Guzman - Monday, February 11, 2013 12:26 AM -
0 Votes
Foreign key to composite key
I created a new table that has a composite key(SemesterID, StudentID, CourseID).Answered | 8 Replies | 11384 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
Hi, You forst create the TableA which is having clientId as primary key. like CREATE TABLE TableA ( ClientID int NOT NULL ...Answered | 6 Replies | 4657 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
Consider the following design: CREATE TABLE [User] ( UserID INT IDENTITY(1,1) Primary Key, UserName nvarchar(50), UserEmail varchar(70) ...Answered | 6 Replies | 1590 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
This is done by means of creating the FK constraint.Answered | 4 Replies | 1226 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 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 | 6971 Views | Created by crazyabtdotnet - Wednesday, October 11, 2006 3:38 PM | Last reply by JoeyDj - Wednesday, October 11, 2006 9:40 PM -
1 Votes
Issue creating Foreign Key in Referenced Table
It is caused by the line FOREIGN KEY (PatientID) references [dbo].Answered | 3 Replies | 766 Views | Created by JaguarsJag - Monday, September 26, 2016 2:28 PM | Last reply by Tom Cooper - Monday, September 26, 2016 4:04 PM -
0 Votes
Foreign Keys
Items ....ItemID (PK) ....Item ....Category (FK) ....Aisle ...Answered | 3 Replies | 604 Views | Created by Exceluser367 - Tuesday, October 6, 2015 8:29 PM | Last reply by Ken Sheridan - Wednesday, October 7, 2015 10:19 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 ...Answered | 4 Replies | 1536 Views | Created by smtaqi - Saturday, August 30, 2014 8:08 AM | Last reply by Visakh16 - Saturday, August 30, 2014 6:59 PM -
1 Votes
Create Foreign Key to Unique Filtered Index
Agree with Scott that unfortunately it is not possible to do a foreign key reference based on filtered index.Answered | 7 Replies | 2521 Views | Created by bambam_Dallas - Thursday, December 19, 2013 4:51 PM | Last reply by bambam_Dallas - Friday, December 20, 2013 3:57 PM -
0 Votes
Discussion of foreign key
What Kent means is that you should always create Foreign Key relationships on tables to ensure relationships are enforced and that poor application coding does not allow ...Answered | 8 Replies | 6943 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
use tempdb Create Table dbo.FooParent(ParentID int primary key) CREATE TABLE dbo.FooChild (ChildID int primary key, ForeignID ...Answered | 11 Replies | 2974 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
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 | 2765 Views | Created by FundamentalGan - Thursday, April 12, 2012 6:00 PM | Last reply by Arbi Baghdanian - Thursday, April 12, 2012 8:08 PM -
5 Votes
create foreign key in xml column in sql server
NO - You won't be able to create foreign key on different datatypes.... also Primary and foreign keys on xml data type is not advisable.... instead of that ...Answered | 2 Replies | 7650 Views | Created by Prem Shah - Sunday, July 10, 2011 5:23 AM | Last reply by Mr. Wharty - Monday, July 11, 2011 9:34 AM -
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 ...Answered | 5 Replies | 1082 Views | Created by carlosadrr - Monday, July 7, 2014 5:20 PM | Last reply by Hilary Cotter - Tuesday, July 8, 2014 3:45 PM -
0 Votes
Foreign key question
Yes, you need to create two Foreign keys.Answered | 2 Replies | 2300 Views | Created by aujong - Monday, April 2, 2012 9:17 PM | Last reply by Naomi N - Monday, April 2, 2012 9:26 PM -
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 | 7476 Views | Created by himengg - Wednesday, May 18, 2011 1:23 PM | Last reply by Stan210 - Thursday, May 19, 2011 12:52 PM - Items 1 to 20 of 1740113 Next ›
No announcements
