Re: Defining keys

> > rossh@ncc.uky.edu (Ross Hayden) writes: > > >Can anyone give me a brief syntax summary of the way to define primary > >or foreign keys using informix 4gl (version 4 I think). > > > Finally, with 5.x and above database engines, there is additional > syntax for designating Primary and Foriegn keys, which I don't know off > the top of my head. See the Reference manual under "CREATE TABLE". > Essentially, though, they do the same thing as we did above: create > unique or non-unique indicies for the appropriate columns. They also create primary 'P' and foreign 'R' constraints. cheers j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| Every DOS PC should run Windows, jparker@hpbs3645.boi.hp.com | It gives them something to do. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________