In Oracle, it is created with help of FORCE VIEW with Create command. But, In case of MS SQL, it is not possible to create a View on table/view that is not exist in database.
For more details, please read my another post on it : Interview-Questions-based-on-practical-understanding