SQL Server 4

First, the View

1. Create a View

1) Select the view in the table in the database, and right-click the new view, which is:

2) in the "Add Table" dialog box, click on the "Table" tab, select the table you want to add, click Add, i.e.:

3) Select the check box for the column name you want to contact, and then drag the column name in one table to the column name in the other table where you want to contact, namely:

4) Save

2. Modify the View

1) Select the view and right click on "design", i.e.:

2) make changes, save

3. Delete a view

Select View, right-click Delete, i.e.:

SQL Server 4