The Best Surrogate Key In Sql References. Some databases provide uuid / guid as a possible data type for surrogate keys (e.g. It does not have any primary keys.
A sybase or sql server identity column, a postgresql or informix serial, an oracle or sql server sequence or a column defined with auto_increment in mysql ). It's just a sheet of data. Web a surrogate key is a system generated (could be guid, sequence, unique identifier, etc.) value with no business meaning that is used to uniquely identify a record in a table.
