. ADD FOREIGN KEY not Index
The help diagram shows index as an option, but I've never seen it used and honestly don't know how it will differ from the key, but the key is an index and will not let you insert a record with a value that doesn't exist in the referenced table which, after all, is the point of primary/foreign keys. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Thursday, November 20, 2008 9:20 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Command for setting Primary and Forign keys in table Tell me if I am right on Primary Alter Table Customer Add Primary Key Case (Custnub2) Tell me if I am right on Foregin Key Alter Table CustContact Add Foreign Index (Custnub2) References Customer Thanks Steve _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Emmitt Dove Sent: Thursday, November 20, 2008 8:57 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Command for setting Primary and Forign keys in table Steve, Try HELP ALTER. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Thursday, November 20, 2008 8:50 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Command for setting Primary and Forign keys in table Can someone give me an example of seeting a primary and forign key in a table from a R: Prompt. Thanks, Steve
