Rails Console Tips: Table Operations

Feb 2nd, 2015 6:04 pm

In rails console, you can

list tables

> ActiveRecord::Base.connection.tables

list a table structure (but it is a protected method)

# this dose not work. 
> ActiveRecord::Base.connection.table_structure("projects")

# we should utilize send method to call protected method
> @c = ActiveRecord::Base.connection
> @c.send(:table_structure, "xxxs") # xxxs is your model name

show table schema

> ActiveRecord::Base.connection.columns :table_name

Comments