Hello,

A question...

In  a table, with a column call ID, GUID type, autogenerated, "CURRENT_GUID"?

Could this columm be the "Primary Key"?

This CURRENT_GUID will always be "UNIQUE" no matter wath in all cases, all time?

I am asking this, because, if you have a table with autogenerated id "integer" as indentity, if for any reason and you "empty" the table, the new record with start with 1 againg. it makes more sense to me, having this GUID column as primary.

thanks for your comments.

Jorge


GUIDs are meant to be globally unique so yes it should be unique in all cases, all time. The universe being what it is I wouldn't guarantee that but have a look at these

https://stackoverflow.com/questions/2977593/is-it-safe-to-assume-a-guid-will-always-be-unique

https://stackoverflow.com/questions/39771/is-a-guid-unique-100-of-the-time

and yes, GUIDs can be the primary ID

Roy Lambert