PK AND FK

[user4fun]

I am sure that some of you are familiar with primary keyt and foreign key in MS ACCESS. how does the same concept wortk with sql.i would appreaciate a link, or explanations or whatever.thank you.

[raviprakashg]

http://www.sqlteam.com/item.asp?ItemID=2599

[aspnetguy]

When using Access it is writing the SQL for you, it is still SQL.Are you asking how to write the Queries by hand in SQL???

[Prakash]

When using Access it is writing the SQL for you, it is still SQL.Are you asking how to write the Queries by hand in SQL???

<{POST_SNAPBACK}>

It works as well as in the Access.Primary Key doesn't allow repetitions and null values.Foreign key is the reference to the Primary key.

[aspnetguy]

It works as well as in the Access.Primary Key doesn't allow repetitions and null values.Foreign key is the reference to the Primary key.

<{POST_SNAPBACK}>

Not exactly. The FK is a reference to another indexed column from another table (not just a PK form another table)

[user4fun]

I am sorry if i was not clear, what i was trying to find out is how to declare PK AND FK link them together and inforce refrential integrity.stuff like thatThank you