Method: Sequel::DB2::DatabaseMethods#tables

Defined in:
lib/sequel/adapters/shared/db2.rb

#tables ⇒ Object

Use SYSCAT.TABLES to get the tables for the database


57
58
59
60
61
 
# File 'lib/sequel/adapters/shared/db2.rb', line 57

def tables
  metadata_dataset.
    with_sql("SELECT TABNAME FROM SYSCAT.TABLES WHERE TYPE='T' AND OWNER = #{literal(input_identifier_meth.call(opts[:user]))}").
    all.map{|h| output_identifier_meth.call(h[:tabname]) }
end