Foreign keys and Secondary keys

Bryan Bungardt

Delphi Developer

Mon, 10 Jan 2005 19:35:15 GMT

Foreign keys and Secondary keys

Hi,

I have 2 questions

- Does Interbase 6 have something like a Secondary Keys ?

- I want to use a Foreign key : And I'm not sure what is better :
- To link to a numeric (autocreated number) field in the foreign table
- or to directly link to the charakter field in the foreign table that I will be needing to present.
What are the Advantages and disadvantages.

When I have multiple foreign keys and I use the numeric, I have to load all the presentation values from the different tables.

thanks,
Bryan

Martijn Tonie

Delphi Developer

Mon, 10 Jan 2005 19:46:10 GMT

Re:Foreign keys and Secondary keys

Hi,

Quote

> I have 2 questions

> - Does Interbase 6 have something like a Secondary Keys ?

As in other unique constraints? Yes, take a look at the UNIQUE
CONSTRAINT in the Language Reference of the InterBase
documentation.

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Other Threads

1. Modify Key Field ( when it's foreign key in another table)

2. Single key vs Alt+key hot keys under Delphi 5

3. Can't I add a foreign Key that references foreign Key of other Table?

4. Null values and foreign keys

5. foreign key: unsuccessfull metadata update

6. !!! help - date query and empty foreign key insertion

7. Foreign keys / paradox...

8. Foreign keys and multi table forms.

9. Foreign keys

10. HOWTO define foreign keys in TTable objects