sqt destroy and reset-target

Destroy selected pipelines while preserving their managed sources and replay data:

sqt destroy \
  --target uat \
  --select pipeline:pl__orders pipeline:pl__reporting

Reset all SQLTide-managed pipeline and source relations in one target:

sqt reset-target --target uat

Standalone destructive commands resolve the local OS username in the same SQLTide account control store used by the development server. The account must be active and hold the built-in admin role. Use --control-store-url when the installation does not use the project-local default store.

The plan and your review are saved in the control store. Immediately before dropping anything, SQLTide reloads your account, recompiles the project and resolves the target database again; if any of them changed since the plan, the command stops without dropping anything.

Both commands:

• require an interactive stdin terminal
• print the complete frozen impact plan before prompting
• require a separate review decision
• prompt separately for every exact, case-sensitive challenge value
• use the same planner, target lock, drift checks, executor, and operation recording as the UI

The commands do not accept non-interactive output or approval options. In particular, there is no --yes, --force, --auto-approve, --confirm, --apply, or --no-confirm option.

Destruction is irreversible. A later build can recreate authored resources, but SQLTide does not restore the dropped data or automatically roll back a partial failure.

See Destructive Operations for exact resource scope, confirmation rules, dependency closure, and retained evidence.