dropForeignKey function

Future<void> dropForeignKey({
  1. required String databaseName,
  2. required String foreignKeyName,
  3. required String table,
})

drops a foreign key from the table

Implementation

Future<void> dropForeignKey({
  required String databaseName,
  required String foreignKeyName,
  required String table,
}) async {
  await Transaction.current.db.query('''
ALTER TABLE `$databaseName`.`$table`
DROP FOREIGN KEY `$foreignKeyName` ;
''');
}