annovarR (version 1.0.0)

drop.sqlite.index: Drop search index of annovarR database table in sqlite

Description

Drop search index of annovarR database table in sqlite

Usage

drop.sqlite.index(sqlite.connect.params = list(dbname = "", table.name = ""),
  index = "", verbose = FALSE, ...)

Arguments

sqlite.connect.params

Connect to sqlite database params [dbname]

index

Index name in sqlite

verbose

Ligical indicating wheather show the log message

...

Other parameters be used in dbSendQuery

Examples

# NOT RUN {
test.sqlite <- sprintf('%s/snp.test.sqlite', tempdir())
test.dat <- system.file('extdata', 'demo/sqlite.dat.txt', package = 'annovarR')
x <- sqlite.build(filename = test.dat, list(dbname = test.sqlite, 
table.name = 'snp_test'))
x <- sqlite.index(list(dbname = test.sqlite, table.name = 'snp_test'), 
index = 'index4', cols = c('V1', 'V2'))
x <- drop.sqlite.index(list(dbname = test.sqlite, table.name = 'snp_test'), index = 'index4')
test.sqlite <- normalizePath(test.sqlite, '/')
file.remove(test.sqlite)
# }