Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    4

    Unanswered: Question regarding foreign key fields and term 'supercede'

    I have been given a schema in informix that contains a statement that looks like this:

    alter table "itis".synonym_links add constraint (foreign key

    *(tsn_accepted)* references "itis".*taxonomic_units* constraint

    "itis".supercede)


    This alter table command references the column *tsn_accepted* in the
    *taxonomic_units* table yet there is no such column in that table.
    There however is a *tsn* in column taxonomic_units. A column named*
    tsn_accepted* is found in the *synonym_links* table. Should the
    instructions read (see below) or am I just reading the instructions
    incorrectly?

    alter table "itis".synonym_links add constraint (foreign key

    (tsn) references "itis".taxonomic_units constraint

    "itis".supercede)

    What does the command 'supercede' mean?

  2. #2
    Join Date
    Aug 2005
    Posts
    140
    alter table "itis".synonym_links add constraint (foreign key

    *(tsn_accepted)* references "itis".*taxonomic_units* constraint

    "itis".supercede)

    this command means:

    you added foreign key (synonym_links.tsn_accepted) which is referencing to primary key in table taxonomic_units.

    "contraint "itis".supercede means that you declared the name of the new contraint. This name must be unique among the names of indexes and constraints in database.
    But this part is not obligatory when you dont declare the name then IDS automatically does.

    hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •