Good explanation but --
1. what means TTBOMK?
2. Since there is no such thing, what do you get when you do the following:
alter table tblname add foreign INDEX (colname) references tbl2 (colname)
3. I have trouble adding the message - what is correct?
<<"message for foreign key">> ?
>TTBOMK there is no such thing as Foreign Index.
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 12:13 PM
Subject: Re: Please explain foreign keys, index - Razzak's Reply
>
> At 04:00 PM 4/7/2002 -0400, Bernie Lis wrote:
>
> >what is diff between foreign key and foreign index?
> >If I create a foreign index is that column indexed for
> >look ups in that table. If I create a foreign key do I
> >still have to build an index for look up in that table?
>
> Bernie,
>
> TTBOMK there is no such thing as Foreign Index.
>
> . An Index is automatically built when a foreign key constraint
> is defined.
>
P.S. please excuse previous missile, hit send instead of delete.
================================================
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/
