I know that the Enterprise-D was capable of saucer separation (this was displayed in several episodes including The Best of Both Worlds, Encounter at Farpoint and in the film Generations). I also know the Prometheus class was capable of saucer separation (albeit in the form of 'multi-vector assault mode'). And according to this question, it seems the good old Constitution class was capable of saucer separation. My question is: what other starships (if any) were capable of saucer-separation? Note I would like to include non-Federation ships as well and would like to stick to canon references.
This Memory Alpha article suggests that the following ships / classes are also capable of seperation although it is never shown directly in a movie or episode:
- Enterprise-A / Constitution class (only as last resort)
- Enterprise-B / Excelsior class
- Enterprise-C / Ambassador class
- Enterprise-E / Sovereign class
The Abrams continuity shows the rebooted 1701 saucer separation. It's done here to allow the saucer to use its own power, after the neck was destroyed. As seen in Star Trek: Beyond (happens towards the end of the clip)
According to the Star Trek: Deep Space Nine Technical Manual, even the Defiant Class possesses this ability, even in a slightly different form (instead of saucer hull it is probably better to speak of primary and secondary hull here).
The notched forward hull containing the vessel's navigational deflector and main sensors was a detachable single-use last-resort missile. This missile was equipped with a small impulse engine and a magazine with six torpedo warheads. These torpedo warheads were part of the ship's auto-destruct system and under more normal circumstances could be fired from the forward launcher. Any torpedo warheads left in the magazine would become the missile's warhead upon the missile's separation from the rest of the ship. If no torpedo warheads remained, then the missile would have to rely on kinetic energy alone. The ship would be unable to travel at high warp speeds without the missile since the latter contained the ship's navigational deflector.
Quote from Memory Alpha