rowguid

[Victor]

hi guys
just want know, if is that rowguid field must be unique in the whole
database? can i get the rowguid from one table then insert into another
table?

 

[Robbe Morris [C# MVP]]

The unqiueness is generally by table and not by database.

 

[Alex Feinman [MVP]]

If the guids are create via CoCreateGuid or similar algorithm, shouldn't
they be *globally* unique?

 

[Victor]

the guid is generated by the newid() function in the sqlce. and will be used
in the repulication as the rowguid column. in that case, can i still use
this guid as a primary key for another table?

cheers

 

[Alex Feinman [MVP]]

Why can't you create another guid?

 

[Victor]

acutally to resolve this problem, i create another column as rowguid, just
feel strange why this happen... want to know whether the rowguid for
replication is unique in the whole database

cheers

 

[Alex Feinman [MVP]]

acutally to resolve this problem, i create another column as rowguid, just
feel strange why this happen... want to know whether the rowguid for
replication is unique in the whole database

I don't see why it shouldn't, but that's my opinion.

 

[Sergey Bogdanov]

I believe you confused it with IDENTITY column. But a ROWGUIDCOL from
the definitition is Globally Unique IDentifier and should be unique for
all tables in all databases within the same device.

Best regards,
Sergey Bogdanov
http://www.sergeybogdanov.com

 

[Robbe Morris [C# MVP]]

I should have been more clear. I was referring to unique
indexes and primary keys in general.

Yes, guid's are definitely globally unique.

--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx