The USS Stargazer was a Constellation-class starship which fought in the Battle of Maxia. Jean-Luc Picard served onboard and had command at the time. The ship was abandoned after the battle and later repaired by a Ferengi Daimon.
The Stargazer was originally intended to be a Constitution-class starship that would reuse the Enterprise model from the TOS movies. However, the producers decided to use a new model, so they changed the designation. "Constellation" was chosen because it could easily be dubbed over "Constitution" in post-production.