Foreign keys can be set in the database to not include indexes unless
specfically required. Check out the fast key option.
Emmitt Dove wrote:
… 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
