The View Designer is a visual tool that can help you build views.
The View Designer is just like the Query Designer, in that it provides a visual way of designing a query. It saves you the trouble of designing the query in Query Designer, then doing the extra coding to convert the query into a view (like we did previouslya).
Now we will use the View Designer to create another view.
Launch the View Designer
Add the Tables
Design the View
Execute the SQL
Save the View
Query the View
Some database developers like to prefix their name view names with v or v_ or similar to help distinguish between views and other database objects.