Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Difference between columns

Author  Topic 

programer
Posting Yak Master

221 Posts

Posted - 2011-03-22 : 05:24:25
Hi,

I have a table
aspnet_membership and tbl_country

aspnet_membership the column UserId uniqueidentifier primary key, and tbl_country ID primarykey autoinc int.

Parent table aspnet_membership:
UserId uniqueidentifier primary key

Child table tbl_country
ID primarykey autoinc int, UserId uniqueidentifier primary key

What is the difference:

Parent table aspnet_membership
UserId uniqueidentifier primary key Relationship With Child table tbl_country UserId uniqueidentifier primary key

and
Parent table aspnet_membership
UserId uniqueidentifier primary key Relationship With Child table tbl_country UserId uniqueidentifier Foreign key.

Is there any difference?
   

- Advertisement -