dropTable method

Future<SqlDatabaseResult> dropTable(
  1. DatabaseDriver conn
)

Drops the table from the MySQL database. Executes a DROP TABLE IF EXISTS statement to safely remove the table from the database. The IF EXISTS clause prevents errors if the table doesn't exist. Parameters:

  • conn - The active MySQL database connection Returns a MySqlResult indicating the success or failure of the drop operation. Example:
var result = await table.dropTable(conn);
if (result.success) {
  print('Table dropped successfully');
}

Implementation

Future<SqlDatabaseResult> dropTable(DatabaseDriver conn) async {
  String sql = 'DROP TABLE IF EXISTS `$name`;';
  return conn.executeString(sql);
}