Various people seem to be of the opinion that if Scotland becomes independent the United Kingdom comes to an end.

This is not my understanding.

When southern Ireland left the United Kingdom in 1922 there was no change in status of the United Kingdom (the new title United Kingdom of Great Britain and Northern Ireland being affirmed in a 1927 Act of Parliament).

Therefore the United Kingdom will continue, whatever the result of the Scottish referendum.