method
columns
v4.0.2 -
Show latest stable
- Class:
ActiveRecord::ConnectionAdapters::AbstractMysqlAdapter
columns(table_name)public
Returns an array of Column objects for the table specified by table_name.
# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 460
def columns(table_name)#:nodoc:
sql = "SHOW FULL FIELDS FROM #{quote_table_name(table_name)}"
execute_and_free(sql, 'SCHEMA') do |result|
each_hash(result).map do |field|
field_name = set_field_encoding(field[:Field])
new_column(field_name, field[:Default], field[:Type], field[:Null] == "YES", field[:Collation], field[:Extra])
end
end
end Related methods
- Instance methods
- adapter_name
- add_column_position!
- add_index
- begin_db_transaction
- begin_isolated_db_transaction
- bulk_change_table
- case_insensitive_comparison
- case_sensitive_modifier
- change_column
- change_column_default
- change_column_null
- charset
- collation
- columns
- commit_db_transaction
- create_database
- create_savepoint
- create_table
- current_database
- disable_referential_integrity
- drop_database
- each_hash
- empty_insert_statement_value
- error_number
- execute
- execute_and_free
- index_algorithms
- indexes
- join_to_update
- limited_update_conditions
- native_database_types
- new_column
- pk_and_sequence_for
- primary_key
- quote
- quote_column_name
- quote_table_name
- quoted_false
- quoted_true
- recreate_database
- release_savepoint
- rename_column
- rename_table
- rollback_db_transaction
- rollback_to_savepoint
- schema_creation
- show_variable
- strict_mode?
- supports_bulk_alter?
- supports_index_sort_order?
- supports_migrations?
- supports_primary_key?
- supports_savepoints?
- supports_transaction_isolation?
- table_exists?
- tables
- type_to_sql
- update_sql
- valid_type?
- Class methods
- emulate_booleans
- new
- Protected methods
-
add_column_sql -
add_index_length -
add_index_sql -
add_timestamps_sql -
change_column_sql -
quoted_columns_for_index -
remove_column_sql -
remove_columns_sql -
remove_index_sql -
remove_timestamps_sql -
rename_column_sql -
subquery_for -
translate_exception - Private methods
-
column_for -
configure_connection -
supports_views?