what's difference between master key and unique key

seman18 · New User Joined: 08 Feb 2009 Posts: 67 Location: hz

what's difference between master key and unique key? thanks in advance.

dbzTHEdinosauer · Posted: Tue Feb 15, 2011 2:21 pm

anyone can use a master key,

but a unique key is held by one person.

enrico-sorichetti · Posted: Tue Feb 15, 2011 6:49 pm

the question as posed does not make any sense!
in what context are the terms used....

in a contextless environment the two terms are not related!

in cryptography
a master key is the key under which all the other keys used are encrypted
or the first key of a multi key encryption system

in database/data management
a unique key is the <thing> that uniquely identifies a row/record!

so You see that You have a loong way to explanations in order to get a proper answer

seman18 · New User Joined: 08 Feb 2009 Posts: 67 Location: hz

sorry, it is datacom, I missed that

dick scherrer · Posted: Wed Feb 16, 2011 9:53 am

Hello,

A "unique" key does not allow duplicate entries.

A Datacom table may have a Master Key and Native Key. You need to read about these in the DBA documentation for your release of Datacom.

Suggest you also look at a CXX report for a few databases and see how these have been used on your system.