Composite Key is a primary key, combination of more than one column to maintain unique record. It is also known as Concatenated Key or Aggregate Key
For example:
CREATE TABLE InvoiceDetails (
      InvoiceNo numeric(18,0),
      itemNumber numeric(18,0),
      productId  int,
      quantity   numeric(18,2),
      PRIMARY KEY (InvoiceNo, itemNumber))
InvoiceDetails table may have a composite key on InvoiceNo & itemNumber
 
 
To learn .net, C#, Java, J2EE, Silverlight, Visual Basic, Asp .net with advanced concepts, you can visit http://advanceddotnettutorial.blogspot.com
ReplyDelete