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



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

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.



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

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



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

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