Module: Sequel::Access::DatabaseMethods

Includes:
UnmodifiedIdentifiers::DatabaseMethods
Included in:
Sequel::ADO::Access::DatabaseMethods
Defined in:
lib/sequel/adapters/shared/access.rb

Instance Method Summary collapse

Instance Method Details

#database_typeObject



13
14
15
# File 'lib/sequel/adapters/shared/access.rb', line 13

def database_type
  :access
end

#rename_table(from_table, to_table) ⇒ Object

Access doesn't support renaming tables from an SQL query, so create a copy of the table and then drop the from table.



24
25
26
27
# File 'lib/sequel/adapters/shared/access.rb', line 24

def rename_table(from_table, to_table)
  create_table(to_table, :as=>from(from_table))
  drop_table(from_table)
end

#serial_primary_key_optionsObject

Access uses type Counter for an autoincrementing keys



30
31
32
# File 'lib/sequel/adapters/shared/access.rb', line 30

def serial_primary_key_options
  {:primary_key => true, :type=>:Counter}
end