Database Reference
In-Depth Information
Figure 8.2
Modify data through view based on single table.
Figure 8.3
Modify data through view with calculated column.
8.2.4 Drop Views
Views that are no longer needed can be deleted from a database with an SQL statement. Like
deleting a table, the DELETE statement is used to delete the content of a view. To delete the data
as well as the structure of a view, you can use the SQL statement DROP VIEW.
ACTIVITY 8.1 CREATING, MANAGING, DROPPING VIEWS
You can create a view by using the CREATE VIEW statement in the
New Query
editor of
SQL Server Management Studio or in Windows Azure SQL Database. Suppose that you
want to create views by using the Windows Azure SQL Database portal to collect student
