Re: Primary Key and Unique Key

From: fniles (anonymous_at_discussions.microsoft.com)
Date: 08/22/04 

Date: Sun, 22 Aug 2004 16:25:17 -0700

Thanks. I am still confused.
So, does it mean that both primary key and unique keys
can also be related to other tables ?
So, what are the difference between the two keys ?
What are the difference between primary key and the
secondary keys ?
Thanks.

>-----Original Message-----
>"Fie Fie Niles" <fniles@wincitesystems.com> wrote in
message
>news:%23tvz2UwhEHA.704@TK2MSFTNGP12.phx.gbl
>> Is it correct that primary key can be related to other
tables, but
>> unique keys don't ?
>
>No
>
>--
>Reply to the group so all can participate
>VB.Net... just say "No"
>
>.
>

Relevant Pages

  • Re: FOREIGN KEY CONSTRAINTS
    ... veracity of your database application. ... keys vs. surrogate keys are available for your reading pleasure. ... surrogate key and a unique index that doesn't allow NULLs on the natural key, ... The EMPID primary key in the employees table remains ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How can you create a field that is concatenated?
    ... keys in relational theory, ... PRIMARY KEY in the SQL language, ... Autonumber in the Jet product. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: M:M/Multiple Keys
    ... hence the use of a composite primary key derived ... from the two foreign keys. ... significant change to your design, you will have to cascade this change all ... I stopped using composite keys many years ago and since then, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Get Primary key from Access db
    ... But i need keys information - especially foreign keys. ... > key or primary key and foreign key... ... >> Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: uniq key and primary key, how they are diffrent?
    ... Primary keys are unique keys. ... Unique keys can either be primary keys or foreign keys. ... Foreign keys are keys to other tables that the the current table can reference. ... in the person table can have a unique key (it's primary key) that can ...
    (comp.os.linux.misc)