Terminating the workflow will set its status to Canceled and will delete all tasks created by the workflow.
Via browser interface

Via code
// Cancel
SPWorkflowManager.CancelWorkflow(workflowProperties.Workflow);
Applies To
- Windows SharePoint Services 3.0 (+ Service Pack 1)
- Microsoft Office SharePoint Server 2007 (+ Service Pack 1)