Difference between Primary Key and Aggregate Key?

Questions by Beena   answers by Beena

Showing Answers 1 - 3 of 3 Answers


  • Oct 7th, 2005

its is not aggregate it is the alternate key

primary key : the column which is used for thr unique identification of a record from a table is called the primary key

alternate key : a column which is used for unique identification but not a primary key is called the alternate key


  • Aug 3rd, 2006

aggregate fact tables have two types of keys

-composite key

-serrogate key (system generated key)

So aggregate-key is a primary key

  Was this answer useful?  Yes

primary key:
is a key on ( 1  or group of columns) used to identify a record uniquely.
builds clustered index automatically

Alternate key:
is a key which is a unique key but not a primary key.
no clustered index builds automatically

surrogate key:
Its a another name for primary or altername key, if created on surrogate column(a column inserted artificially i.e. identity column).

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions