# Dynamic database table

**URL:** <https://www.ruby-forum.com/t/dynamic-database-table/115151>\
**Category:** Rails\
**Created:** [September 21, 2007, 3:11am UTC](https://www.ruby-forum.com/t/dynamic-database-table/115151 "2007-09-21T03:11:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![inrila](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/a3d4f5/32.png) [@inrila](https://www.ruby-forum.com/u/inrila)\
**Post date:** [September 21, 2007, 3:11am UTC](https://www.ruby-forum.com/t/dynamic-database-table/115151/1 "2007-09-21T03:11:17Z")

</div>

Just out of curiosity,

Is it possible with RoR (to be more exact - with ActiveRecord) to  
create database table “on fly”, from the application?

---

<div class="post-metadata">

**Author:** ![inrila](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/a3d4f5/32.png) [@inrila](https://www.ruby-forum.com/u/inrila)\
**Post date:** [September 21, 2007, 4:17am UTC](https://www.ruby-forum.com/t/dynamic-database-table/115151/2 "2007-09-21T04:17:25Z")

</div>

> Is it possible with RoR (to be more exact - with ActiveRecord) to  
> create database table “on fly”, from the application?

certainly, if the configured db login has create table privilege, then  
just call following in your code.

ActiveRecord::Base.connection.create\_table :table1 do |t|  
t.column :name, :string  
t.column :description, :string  
end

but personally I never add drop table dynamically, sounds scary.

Dorren  
[http://groups.wuyaSea.com](http://groups.wuyaSea.com) — blog, evolved.