Bernie, sind Sie Deutsch-sprecher? I ask due to some of the phrasing in your e-mails and I was curious.
Additionally, ROTFL means Rolling On The Floor Laughing, a compliment of the highest order when it comes to humor. Later, Steve in Memphis > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Bernard Lis > Sent: Tuesday, April 09, 2002 7:14 PM > To: [EMAIL PROTECTED] > Subject: Re: Please explain foreign keys, index - Razzak's Reply > > > 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/
