Movie request
In the 90s, i think, I saw a movie were a pocket sized inter-dimensional cop, with a gun that can blow the limbs off of a normal sized person, comes to our dimension and helps a detective solve a crime.
Thats all I can remember. Thanks in advance to anybody that would have any clues to the title.