Обсуждение: table constraints vs column
Is there any argument to support using table constraints over column constraints in a situation where there are no PKs or FK references that are composed of more than one column?
Is the automatic PK index generated on for table constraints or for either?
Jodi
Is the automatic PK index generated on for table constraints or for either?
Jodi
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu
On Fri, Sep 26, 2003 at 08:35:54 -0400, Jodi Kanter <jkanter@virginia.edu> wrote: > Is there any argument to support using table constraints over column > constraints in a situation where there are no PKs or FK references that > are composed of more than one column? Functionally they should be the same, so I think it is more of a style issue. > Is the automatic PK index generated on for table constraints or for either? > Jodi Foreign key references do not create indexes. There already needs to be an existing unique index (primary key will generate a unique index) on the table being referenced or the constraint creation will fail. Optionally you may also want to create an index on the referencing columns if you will be doing lots of deletes (and I think updates before 7.4) on the referenced table.