Re: Add Foreign Keys To Table

On 07/07/11 1:02 PM, Rich Shepard wrote:
> On Thu, 7 Jul 2011, Alan Hodgson wrote:
>
>> create unique index index_name on table (column).
>
> Alan,
>
> This worked like a charm.
>
> Many thanks for the lesson,
>
> Rich
>

if your original table has Primary Key of (sta_type, secondary_type) I
would not expect EITHER of those fields to be unique by themselves....
Surely there can be more than one of the same sta_type with different
secondary_type's, just as there could be more than one secondary_type
with different sta_types.... if either of these fields is unique of
and by itself, it doesn't make sense to use the combined primary key.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast