Views can be used to show the results of computed columns.

More Questions from SQL for Database Construction

• Common types of SQL CHECK constraints include range checks and limiting columns values.
• The SQL DELETE statement is used to delete both the table structure and table data.
• SQL statements can be embedded in triggers, stored procedures, and program code.
• There are three SQL data modification operations: insert, modify and delete.
• If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
• A trigger is a stored program that is attached to a database.
• SQL Server does not support the BEFORE trigger.
• A stored procedure is a program that performs some common action on database data and is stored in the database.
• The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
• Three types of triggers are: BEFORE, AFTER and EXCEPTION.

Discussion & Comments