Choose any three.
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.