Last chance! 50% off unlimited learning
Sale ends in
List all indices on an Andromeda table
listIndices(tbl)
Returns a tibble listing the indices, indexed columns, and whether the index is unique.
An Andromeda
table (or any other 'DBI' table).
Lists any indices that may have been created using the createIndex()
function.
createIndex()
, removeIndex()
andr <- andromeda(cars = cars)
createIndex(andr$cars, "speed")
listIndices(andr$cars)
# # A tibble: 1 x 5
# indexSequenceId indexName unique columnSequenceId columnName
#
#1 0 idx_ocy8we9j2i7ld0rshgb4 FALSE 0 speed
close(andr)
Run the code above in your browser using DataLab