The SB-700 has several options and possibilities.
It has a menu where you can select Manual, TTL, or GN modes. Manual flash, you determine and set the flash power level, however you want to control it. TTL mode has to be on hot shoe, but then the camera automation meters it (controlled with Flash Compensation). GN mode, you enter the subject distance into the flash, and it knows the right power level (which has advantage that it is not affected by how well the subject reflects light, but disadvantage that it is direct flash only).
Or it has Remote Mode, where it is controlled wirelessly by a Commander at the camera. This is remote flash which can include multiple TTL flash. SB-700 can also be a Commander to control other Remotes, but it must be attached to the camera to do it.
It has the SU-4 mode, also remote flash, which is triggered by the flash of any other manual flash (more reliably and at greater distance than the Commander can do it). But it is Manual flash mode.
It does not have a PC sync connector, but an inexpensive adapter on flash foot can provide one. Manual flash again.
Or one could add radio triggers, which are popular, and also manual flash. But SU-4 mode works really well indoors.