The officer concerned today submitted his resignation and it was accepted with immediate effect.
Commander Allan Gibson said: "This officer's behaviour was completely unacceptable and it is right that he resigned."
The officer chose to resign immediately prior to his suspension being put in place.
More top news
More than 1.85 million people have called for the US president's visit to be watered down to avoid causing "embarrassment" to the Queen.
Jim Mattis arrived in Baghdad on the day after US-backed Iraqi forces launched an operation to reclaim Mosul from IS.
The scale of the blood poisoning disease sepsis is "far worse" than previously thought thanks to a "crippling" lack of data, a study says.