Why do you want to restrict the names to be unique?
//Anders - SQL, QUERY
-Original Message-
From: Shaun Bramley
To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Sent: 3-5-02 20:16
Subject: Re: Simple Question relating to Indexing
I'd like to first thank Carl and Anders for
hno-Mage
* http://www.calevans.com
*
-Original Message-
From: Shaun Bramley [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 1:17 PM
To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Subject: Re: Simple Question relating to Indexing
I'd like to first thank Carl and Anders for your quick
Sent: Friday, May 03, 2002 1:11 PM
Subject: RE: Simple Question relating to Indexing
> > Hello all being relatively new on the SQL scene I must say some of the
> > concepts are a little new and strange to me. My really big question is
what
> > is the difference between an index
> Hello all being relatively new on the SQL scene I must say some of the
> concepts are a little new and strange to me. My really big question is what
> is the difference between an index and a key? are the synonamous with each
> other?
A key will identifying a row or several rows. Just like yo
I'll take a stab at this.
A key is a value that you can use in a table and relate it to another table.
In this usage you will hear people talk of primary keys and foreign keys.
A primary key is a value that uniquely identifies a record in a table. With
VERY FEW exceptions, all tables should hav