Many goby fishes and all sand-sifting starfish will eat the animals that make the sand live. That goes to some degree for hermit crabs and many other fishes as well.
It's possible to remove a sandbed by siphoning it out of the tank, if the live rock isn't supported by the sand. Otherwise, reassembly required, although the reassembly is not that hard, in general.