unique key/keys

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SHIRA - 01 Dec 2005 15:21 GMT

I am working on a database that i didn't build,there is so many table and i
want to understand what is/are the unique key for each table,does someone
know a quick way to do it?

Reply to this Message

mscertified - 01 Dec 2005 16:16 GMT

Go into table design and look for a primary key. This will always be a unique
value.
You can also have other indexes that are unique. You need to click on each
column and look for the property 'indexed no duplicates'.
Also, check out menu option ' Tools--Analyze--Table' - it may help you with
this task.

Dorian

> I am working on a database that i didn't build,there is so many table and i
> want to understand what is/are the unique key for each table,does someone
> know a quick way to do it?

Reply to this Message

mscertified - 01 Dec 2005 16:26 GMT

I sould have said Tools--Analyze--Documenter

Dorian

> Go into table design and look for a primary key. This will always be a unique
> value.
[quoted text clipped - 8 lines]
> > want to understand what is/are the unique key for each table,does someone
> > know a quick way to do it?

Reply to this Message