You can restore full databases or partial SQL Server databases to the current location (in place), to a different location (out of place, database copy), or directly to a disk.
You can restore individual tables only on SQL clones. For more information, see Cloning a SQL Database.
For a video about SQL database restores, see How to perform a SQL database restore.