Index

Removes an index from a table.

Command

$ eucalypt migration drop index
# Alias/shortened
$ eucalypt m drop index
$ eucalypt m drop i
$ eucalypt m d i

Arguments

• [TABLE] - The name of the table.

• *[COLUMNS] - The columns of the table that the index should be removed from.

Options/flags

• --name alias -n

  The name of the index to remove (if this flag is active, the *[COLUMNS] argument should be empty).

Examples

• $ eucalypt m drop index games opening

  Removes the index on the opening column of the games table.

• $ eucalypt m drop index games white_elo black_elo

  Removes the joint index on the white_elo and black_elo columns of the games table.

• $ eucalypt m drop index games -n index_games_on_opening

  Removes the index_games_on_opening index on the games table.