There are several uses for views. The following are some of the key causes: help make database structure more understandable to users. DBAs use this as a security measure to let users to view data without giving them access rights to the underlying base tables.

1. In Object Explorer, expand the database where you want to create your new view.
2. Right-click the Views folder, then select New View

SQL Server Management Studio should be used.
Expand the database where you want to create your new view in Object Explorer.
Right-click the Views folder and choose New View.