Ask the server to list the indices for the table. If the primary key is included in that list, then it's highly likely that the primary key is an index with a unique constraint. This is so in MySQL, for instance.
Wade.
Indexes and primary keys - redundant?
- (tablizer)
- (9)
- June 22, 2005, 04:43:16 PM EDT
I can't recall every having an index on the primary key
- (jbrabeck)
- June 22, 2005, 04:16:09 PM EDT
As I understand it
- (tuberculosis)
- (1)
- June 22, 2005, 06:57:51 PM EDT
It's definitely the case with Oracle.
-NT
- (Meerkat)
- June 25, 2005, 09:30:22 AM EDT
The Primary Key is an Index.
- (ChrisR)
- June 22, 2005, 07:26:24 PM EDT
Conceptually no, in practice yes
- (JayMehaffey)
- (3)
- June 22, 2005, 10:40:41 PM EDT
Relational theory does not address indexes
- (tablizer)
- (2)
- June 22, 2005, 11:10:09 PM EDT
Indexes are just tables....
- (ChrisR)
- (1)
- June 22, 2005, 11:24:01 PM EDT
Re: just tables.
- (mmoffitt)
- June 23, 2005, 10:36:27 AM EDT
Check the index list.
- (static)
- June 23, 2005, 01:11:11 AM EDT