I wonder if Nicola Sturgeon will now call for a second referendum?
If she called it right now she'd pretty much destroy her ambition of independent Scotland forever.
People keep saying stuff like "Well at least now we'll get indyref2" and "Indyref 2 when?" without realising that general support for Scottish independence has gone down, not up. If another referendum were to be called now and the result was another No, then it'd destroy any potential argument for another referendum anytime in the next 50-100 years.
Even in the unlikely result of a Yes vote, that would be Scotland cutting its nose to spite its face. Scotland would then be facing the prospect of leaving both the UK
AND the EU, and no, there is no possibility of Scotland retaining its EU membership. The EU made that perfectly clear during the last referendum, despite Alec Salmond's dreamworld insistence to the contrary (Much like his currency union delusions).
Scotland would basically be put into the Hard Brexit No deal position and then be starting from scratch. Amongst all that economic turmoil it'd need to find some way to adopt the Euro in order to begin the application process for joining the EU, then be faced with economic tests lasting years before any hope of joining the EU could begin to become a reality.
Leaving the UK would, in the short to mid term, absolutely be a bigger disaster for Scotland than Brexit, and there's no guarantee of it being any better in the long term either, and the odds certainly wouldn't be good.