The DBI package has a function dbListFields that can help here.
An example where I use your name myDb and remote_table using examples from dbplyr website
myDb <- DBI::dbConnect(RSQLite::SQLite(), path = ":memory:")
dplyr::copy_to(myDb, nycflights13::flights, "remote_table",
temporary = FALSE,
indexes = list(
c("year", "month", "day"),
"carrier",
"tailnum",
"dest"
)
)
DBI::dbListTables(myDb)
#> [1] "remote_table" "sqlite_stat1" "sqlite_stat4"
DBI::dbListFields(myDb, "remote_table")
#> [1] "year" "month" "day" "dep_time"
#> [5] "sched_dep_time" "dep_delay" "arr_time" "sched_arr_time"
#> [9] "arr_delay" "carrier" "flight" "tailnum"
#> [13] "origin" "dest" "air_time" "distance"
#> [17] "hour" "minute" "time_hour"