Re: primary key and uniqueness

From: "Martin A. Marques" <martin@math.unl.edu.ar> > >On Sat, 24 Jun 2000, Obnoxio The Clown wrote: > > From: "Martin A. Marques" <martin@math.unl.edu.ar> > > > >So with PRIMARY KEY I get it all! Do I get some other constraint? > > > > In what way? > >I mean, if the colum is declared as a PRIMARY KEY, then it will be UNIQUE >too? Well, yes. > > >One last one. Is it posible to reference a field on a table to a field >on > > >another table that is not a PRIMARY KEY? > > > > No. Not using declarative syntax, anyway. > >What do you mean with declarative syntax? If you respond RTFM, at least >tell >me what FM. ;-) Declarative syntax means using "ALTER TABLE blah...REFERENCES foo" As to which FM, I strongly recommend the guide to SQL Syntax, and probably the SQL tutorial too... >Thanks, and I got the tables created just as I wanted. :-) > >"And I'm happy, because you make me feel good, about me." - Melvin Udall I'm very happy for you too. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com