# How to disable auto-increment in primary key

**URL:** <https://www.ruby-forum.com/t/how-to-disable-auto-increment-in-primary-key/166935>\
**Category:** Rails\
**Created:** [May 1, 2009, 5:47am UTC](https://www.ruby-forum.com/t/how-to-disable-auto-increment-in-primary-key/166935 "2009-05-01T05:47:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vipin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/edb3f5/32.png) [@Vipin](https://www.ruby-forum.com/u/Vipin)\
**Post date:** [May 1, 2009, 5:47am UTC](https://www.ruby-forum.com/t/how-to-disable-auto-increment-in-primary-key/166935/1 "2009-05-01T05:47:26Z")

</div>

How can i disable the auto-increment for a primary key data type. The  
purpose of using primary\_key data type is using different name for  
primary key. But we still want to use all the properties of “id”  
except for auto increment part.

I had my migration as following  
#=============MIGRATION  
def self.up  
create\_table :pk2s , :id=\> false do |t|  
t.primary\_key :uid  
t.string :name

```
  t.timestamps
end

```

end

# ========== Model

class Pk2 \< ActiveRecord::Base  
set\_primary\_key “uid”  
end

–vipin

---

<div class="post-metadata">

**Author:** ![Vipin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/edb3f5/32.png) [@Vipin](https://www.ruby-forum.com/u/Vipin)\
**Post date:** [May 1, 2009, 10:39pm UTC](https://www.ruby-forum.com/t/how-to-disable-auto-increment-in-primary-key/166935/2 "2009-05-01T22:39:02Z")

</div>

Vipin wrote:

> How can i disable the auto-increment for a primary key data type. The  
> purpose of using primary\_key data type is using different name for  
> primary key. But we still want to use all the properties of “id”  
> except for auto increment part.

Given that it looks to me like you want to implement uuid fields in your  
application maybe this will help:

> **[Caseysoftware](https://caseysoftware.com/?q=node%2F143&title=Using-UUID%2FGUID-as-Primary-Key-in-Rails)**
>
> Caseysoftware -