dropIndex method

Future<void> dropIndex(
  1. String name
)

Helper to drop index (skips if not exists)

Implementation

Future<void> dropIndex(String name) async {
  final sql = switch (dbType) {
    DatabaseType.mysql => 'DROP INDEX IF EXISTS $name;',
    _ => 'DROP INDEX IF EXISTS $name;',
  };
  await connection.execute(sql);
}