Using GUID's As Primary Keys

The latest 4.1 and 4.2 adapters have built in support for Rails UUID support.*

Since this commit, we fully support GUID as primary keys. It is easy to get back GUID's for existing records as your identity columns. However, you will have to setup a few model callbacks if you want to set the identity when a record is being created. In this example below the [guid_field] is the GUID column type. We are setting it to be the #id column and when new records are created, setting the string ID.

class SqlServerEdgeSchema < ActiveRecord::Base
  
  set_primary_key :guid_field
  before_create :set_guid_column
  
  protected
  
  def set_guid_column
    self[:guid_field] ||= connection.newid_function
  end
  
end

Related Information

• Rails Core Group - UUID Primary Keys For ActiveRecord
• No SQL Server System Function For Unique Identifiers