It only locks one table at a time (and I don't think it locks the full table either, but only the smallest index).

Then again, there should rarely be any reason to run this command on SQL 2005 and later.