# Support for foreign keys in Migrations

**URL:** <https://www.ruby-forum.com/t/support-for-foreign-keys-in-migrations/52771>\
**Category:** Rails\
**Created:** [January 18, 2006, 11:32pm UTC](https://www.ruby-forum.com/t/support-for-foreign-keys-in-migrations/52771 "2006-01-18T23:32:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![stenzer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/fbc32d/32.png) [@stenzer](https://www.ruby-forum.com/u/stenzer)\
**Post date:** [January 18, 2006, 11:32pm UTC](https://www.ruby-forum.com/t/support-for-foreign-keys-in-migrations/52771/1 "2006-01-18T23:32:32Z")

</div>

Is there any work being done to add support for defining foreign keys in  
ActiveRecord Migrations? If not is it something that people would find  
useful or do most people here believe in the “Application Database”  
style  
over the “Integration Database” style [1] as defined by Fowler?

I’d love to see support for foreign keys in Migrations. For selfish  
reasons  
I’d be most interested in such support for SQL Server and Oracle.

Cheers,  
Steve

[1] [DatabaseStyles](http://martinfowler.com/bliki/DatabaseStyles.html)

---

<div class="post-metadata">

**Author:** ![stenzer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/fbc32d/32.png) [@stenzer](https://www.ruby-forum.com/u/stenzer)\
**Post date:** [January 19, 2006, 12:08am UTC](https://www.ruby-forum.com/t/support-for-foreign-keys-in-migrations/52771/2 "2006-01-19T00:08:38Z")

</div>

This plugin does it for mysql & postgre.  
[http://wiki.rubyonrails.org/rails/pages/Foreign+Key+Schema+Dumper+Plugin](http://wiki.rubyonrails.org/rails/pages/Foreign+Key+Schema+Dumper+Plugin)

---

<div class="post-metadata">

**Author:** ![stenzer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/fbc32d/32.png) [@stenzer](https://www.ruby-forum.com/u/stenzer)\
**Post date:** [January 19, 2006, 12:15am UTC](https://www.ruby-forum.com/t/support-for-foreign-keys-in-migrations/52771/3 "2006-01-19T00:15:45Z")

</div>

Joshua B. wrote:

> This plugin does it for mysql & postgre.  
> [http://wiki.rubyonrails.org/rails/pages/Foreign+Key+Schema+Dumper+Plugin](http://wiki.rubyonrails.org/rails/pages/Foreign+Key+Schema+Dumper+Plugin)

maybe a little simpler - but so far servicing my needs, hadn’t looked at  
the other one until now.

[http://blog.alancfrancis.com/2005/11/add\_foreign\_key.html](http://blog.alancfrancis.com/2005/11/add_foreign_key.html)

---

<div class="post-metadata">

**Author:** ![stenzer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/fbc32d/32.png) [@stenzer](https://www.ruby-forum.com/u/stenzer)\
**Post date:** [January 19, 2006, 3:25am UTC](https://www.ruby-forum.com/t/support-for-foreign-keys-in-migrations/52771/4 "2006-01-19T03:25:28Z")

</div>

Joshua/Darragh,

Thanks for the pointers to the plugins!