Charles When you create a PK or FK on a column, R:Base puts the error traps into place AND creates indexes on the columns. THere is no need for an index as well on the colum and it won't be allowed.
David BLocker ----- Original Message ----- From: "Charles Parks" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 04, 2002 9:52 AM Subject: Keys vs Indexes > If there is a primarykey on the table does that count the same as an index > for the column it is on? > I was tracing the structure on Saturday and it would complain about > duplicate indexes are not acceptable. > > If there is a foreingkey for a column would it need an index? > Would a foreignkey conflict with an index if there were on the same column? > > Thanks, > Charlie > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
