IMHO, TTBOMK= To The Best Of My Knowledge Mike Sinclair
Bernard Lis wrote: > 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/ ================================================ 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/
