function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
risharisha 

can any one tell the example for composite key

can any one tell the example for composite key in salesforce.pls

AshlekhAshlekh

Hi,

 

I think this will help you if you have idea of database.

 

In our database we have tables and in every table we usually define columns and every columns have their attribute most we say tables have constrains. This constrains are like Unique,Primary key , Foreign key, not null.

 

In salesforce we know we have Id for a record and Id is a primary key in our table . By id we can recoginze a record in date base. Composite key is made of two value of in record and it is unique in our table.

 

Primary key is refer to one column and composite key is made of two columns and Primary key is unique and composite key is also unique.

 

Eg:

 

id  |  name  | PhoneNo  |  age

----------------------------------------

1   |   a          |   18767       | 13

2   |   a          |    12345      | 13

 

here id is unique and you can see name is not unique but if we combine name and Phone no then it is unique.

 

Thanks

Ashlekh

 

If my post helps you then please mark it as soluiton and don't forget to give me kuso's
risharisha

thank you
AshlekhAshlekh

If this is your solution or this post help you than mark it as a solution and don't forget to give me kudo's

 

Thanks,

Ashlekh