Views can be created using Transact-SQL statements or through Enterprise Manager. Enterprise Manager also provides a Create View Wizard that will step you through the creation of a view. The Create View Wizard can be accessed via the Wizards option in the Tools menu.
This section will first present some guidelines and restrictions for creating views which are applicable no matter which tool you choose.
Guidelines for Creating Views
When creating a view, consider using an intuitive name that identifies it as a view, such as dbo.emp_list_view. The owner name is optional, but it should be specified as dbo to avoid broken ownership chains (assuming the referenced objects are also owned by dbo). When the view is created, the existence ...