*** DRAFT ***

SQLite Requirement Matrix Details
lang_dropview.html

Index Summary Markup Original


R-17817-11638-56695-58140-59307-16910-19540-39427 tcl slt th3 src

Canonical usage: syntax/drop-view-stmt.html

th3/cov1/build13.test:32

/* IMP: R-17817-11638 */
# EVIDENCE-OF: R-17817-11638 -- syntax diagram drop-view-stmt

R-27002-52307-56024-23951-62365-30891-30149-50327 tcl slt th3 src

The DROP VIEW statement removes a view created by the CREATE VIEW statement.

slt/slt_lang_dropview.test:19   tcl/e_dropview.test:92   th3/cov1/build13.test:53

/* IMP: R-27002-52307 */
# EVIDENCE-OF: R-27002-52307 The DROP VIEW statement removes a view
# created by the CREATE VIEW statement.

R-00359-41639-41144-27010-59632-30416-37191-53432 tcl slt th3 src

The view definition is removed from the database schema, but no actual data in the underlying base tables is modified.

slt/slt_lang_dropview.test:44   tcl/e_dropview.test:114

/* IMP: R-00359-41639 */
# EVIDENCE-OF: R-00359-41639 The view definition is removed from the
# database schema, but no actual data in the underlying base tables is
# modified.

R-18673-21346-54823-18159-41507-63066-50898-24427 tcl slt th3 src

The view to drop is identified by the view-name and optional schema-name specified as part of the DROP VIEW statement. This reference is resolved using the standard procedure for object resolution.

slt/slt_lang_dropview.test:22   th3/cov1/build13.test:56

/* IMP: R-18673-21346 */
# EVIDENCE-OF: R-18673-21346 The view to drop is identified by the
# view-name and optional schema-name specified as part of the DROP VIEW
# statement. This reference is resolved using the standard procedure for
# object resolution.

R-25558-37487-19096-36063-17437-04044-36041-27526 tcl slt th3 src

If the specified view cannot be found and the IF EXISTS clause is not present, it is an error.

tcl/e_dropview.test:161   th3/cov1/build13.test:36

/* IMP: R-25558-37487 */
# EVIDENCE-OF: R-25558-37487 If the specified view cannot be found and
# the IF EXISTS clause is not present, it is an error.

R-07490-32536-65444-08514-64358-21801-57919-13418 tcl slt th3 src

If the specified view cannot be found and an IF EXISTS clause is present in the DROP VIEW statement, then the statement is a no-op.

tcl/e_dropview.test:174   th3/cov1/build13.test:44

/* IMP: R-07490-32536 */
# EVIDENCE-OF: R-07490-32536 If the specified view cannot be found and
# an IF EXISTS clause is present in the DROP VIEW statement, then the
# statement is a no-op.