*** DRAFT ***

SQLite Requirement Matrix Details
lang_altertable.html

Index Summary Markup Original


R-01610-34403-13857-15414-33964-29900-30338-20168 tcl slt th3 src

Canonical usage: syntax/alter-table-stmt.html

/* IMP: R-01610-34403 */
# EVIDENCE-OF: R-01610-34403 -- syntax diagram alter-table-stmt

R-31123-40510-62836-33024-03707-50987-44237-10899 tcl slt th3 src

Canonical usage: syntax/column-def.html

/* IMP: R-31123-40510 */
# EVIDENCE-OF: R-31123-40510 -- syntax diagram column-def

R-58357-19560-14510-43797-18724-26881-43398-49088 tcl slt th3 src

Canonical usage: syntax/column-constraint.html

/* IMP: R-58357-19560 */
# EVIDENCE-OF: R-58357-19560 -- syntax diagram column-constraint

R-16034-36351-16427-33922-56159-26588-08885-58307 tcl slt th3 src

Canonical usage: syntax/conflict-clause.html

/* IMP: R-16034-36351 */
# EVIDENCE-OF: R-16034-36351 -- syntax diagram conflict-clause

R-63282-43996-47481-25333-53243-51474-00238-17595 tcl slt th3 src

Canonical usage: syntax/expr.html

/* IMP: R-63282-43996 */
# EVIDENCE-OF: R-63282-43996 -- syntax diagram expr

R-10696-30084-53665-51146-23084-19397-22440-65131 tcl slt th3 src

Canonical usage: syntax/filter.html

/* IMP: R-10696-30084 */
# EVIDENCE-OF: R-10696-30084 -- syntax diagram filter

R-60581-03341-52039-04890-58008-25772-53660-37704 tcl slt th3 src

Canonical usage: syntax/raise-function.html

/* IMP: R-60581-03341 */
# EVIDENCE-OF: R-60581-03341 -- syntax diagram raise-function

R-61628-17125-33025-56567-55142-03215-04610-55795 tcl slt th3 src

Canonical usage: syntax/select-stmt.html

/* IMP: R-61628-17125 */
# EVIDENCE-OF: R-61628-17125 -- syntax diagram select-stmt

R-47013-63517-59451-29791-27627-32329-00299-29666 tcl slt th3 src

Canonical usage: syntax/common-table-expression.html

/* IMP: R-47013-63517 */
# EVIDENCE-OF: R-47013-63517 -- syntax diagram common-table-expression

R-21508-23055-03544-43069-03700-52529-28655-04212 tcl slt th3 src

Canonical usage: syntax/compound-operator.html

/* IMP: R-21508-23055 */
# EVIDENCE-OF: R-21508-23055 -- syntax diagram compound-operator

R-23545-53633-60682-12631-15952-36070-08340-26441 tcl slt th3 src

Canonical usage: syntax/join-clause.html

/* IMP: R-23545-53633 */
# EVIDENCE-OF: R-23545-53633 -- syntax diagram join-clause

R-46541-20938-58372-53058-01043-12045-25030-53791 tcl slt th3 src

Canonical usage: syntax/join-constraint.html

/* IMP: R-46541-20938 */
# EVIDENCE-OF: R-46541-20938 -- syntax diagram join-constraint

R-27408-41206-06272-65057-49531-23299-28505-37113 tcl slt th3 src

Canonical usage: syntax/join-operator.html

/* IMP: R-27408-41206 */
# EVIDENCE-OF: R-27408-41206 -- syntax diagram join-operator

R-16212-04751-50585-08411-35285-00447-20753-02198 tcl slt th3 src

Canonical usage: syntax/ordering-term.html

/* IMP: R-16212-04751 */
# EVIDENCE-OF: R-16212-04751 -- syntax diagram ordering-term

R-62030-13484-53274-47431-56373-62021-33007-11272 tcl slt th3 src

Canonical usage: syntax/result-column.html

/* IMP: R-62030-13484 */
# EVIDENCE-OF: R-62030-13484 -- syntax diagram result-column

R-28724-59332-25400-14786-42579-47587-28356-56547 tcl slt th3 src

Canonical usage: syntax/table-or-subquery.html

/* IMP: R-28724-59332 */
# EVIDENCE-OF: R-28724-59332 -- syntax diagram table-or-subquery

R-27989-13151-39943-32082-13046-13205-21280-24214 tcl slt th3 src

Canonical usage: syntax/window-defn.html

/* IMP: R-27989-13151 */
# EVIDENCE-OF: R-27989-13151 -- syntax diagram window-defn

R-16609-30688-17519-40340-07426-24422-28783-40081 tcl slt th3 src

Canonical usage: syntax/frame-spec.html

/* IMP: R-16609-30688 */
# EVIDENCE-OF: R-16609-30688 -- syntax diagram frame-spec

R-16212-04751-50585-08411-35285-00447-20753-02198 tcl slt th3 src

Canonical usage: syntax/ordering-term.html

/* IMP: R-16212-04751 */
# EVIDENCE-OF: R-16212-04751 -- syntax diagram ordering-term

R-61799-10930-44534-31448-13840-52745-27312-15341 tcl slt th3 src

Canonical usage: syntax/foreign-key-clause.html

/* IMP: R-61799-10930 */
# EVIDENCE-OF: R-61799-10930 -- syntax diagram foreign-key-clause

R-31509-35291-02084-41894-63319-63663-58586-07091 tcl slt th3 src

Canonical usage: syntax/literal-value.html

/* IMP: R-31509-35291 */
# EVIDENCE-OF: R-31509-35291 -- syntax diagram literal-value

R-10061-51853-18488-63481-25877-45384-53744-51666 tcl slt th3 src

Canonical usage: syntax/signed-number.html

/* IMP: R-10061-51853 */
# EVIDENCE-OF: R-10061-51853 -- syntax diagram signed-number

R-31272-00274-62255-43298-23904-43777-05391-16185 tcl slt th3 src

Canonical usage: syntax/type-name.html

/* IMP: R-31272-00274 */
# EVIDENCE-OF: R-31272-00274 -- syntax diagram type-name

R-10061-51853-18488-63481-25877-45384-53744-51666 tcl slt th3 src

Canonical usage: syntax/signed-number.html

/* IMP: R-10061-51853 */
# EVIDENCE-OF: R-10061-51853 -- syntax diagram signed-number

R-32485-24703-27801-29483-21531-11705-09294-53002 tcl slt th3 src

The RENAME TO syntax changes the name of table-name to new-table-name.

th3/req1/altertable01.test:33

/* IMP: R-32485-24703 */
# EVIDENCE-OF: R-32485-24703 The RENAME TO syntax changes the name of
# table-name to new-table-name.

R-18692-17694-63404-11739-00590-02418-57066-37741 tcl slt th3 src

If the table being renamed has triggers or indices, then these remain attached to the table after it has been renamed.

th3/req1/altertable01.test:44

/* IMP: R-18692-17694 */
# EVIDENCE-OF: R-18692-17694 If the table being renamed has triggers or
# indices, then these remain attached to the table after it has been
# renamed.

R-10948-48115-30420-45129-26938-33308-29061-07454 tcl slt th3 src

The ADD COLUMN syntax is used to add a new column to an existing table.

th3/req1/altertable01.test:101

/* IMP: R-10948-48115 */
# EVIDENCE-OF: R-10948-48115 The ADD COLUMN syntax is used to add a new
# column to an existing table.

R-23336-07085-33379-01813-11813-48961-61224-20101 tcl slt th3 src

The new column is always appended to the end of the list of existing columns.

th3/req1/altertable01.test:104

/* IMP: R-23336-07085 */
# EVIDENCE-OF: R-23336-07085 The new column is always appended to the
# end of the list of existing columns.

R-14302-38934-55936-51388-09326-06316-22131-13547 tcl slt th3 src

The new column may take any of the forms permissible in a CREATE TABLE statement, with the following restrictions:

th3/req1/altertable01.test:107

/* IMP: R-14302-38934 */
# EVIDENCE-OF: R-14302-38934 The new column may take any of the forms
# permissible in a CREATE TABLE statement, with the following
# restrictions:

R-45735-05060-45707-02597-62787-16150-27278-23647 tcl slt th3 src

The column may not have a PRIMARY KEY or UNIQUE constraint.

th3/req1/altertable01.test:127

/* IMP: R-45735-05060 */
# EVIDENCE-OF: R-45735-05060 The column may not have a PRIMARY KEY or
# UNIQUE constraint.

R-37287-38238-38896-00540-17030-60706-04523-55035 tcl slt th3 src

The column may not have a default value of CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP, or an expression in parentheses.

th3/req1/altertable01.test:138

/* IMP: R-37287-38238 */
# EVIDENCE-OF: R-37287-38238 The column may not have a default value of
# CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP, or an expression in
# parentheses.

R-29868-13536-10966-03336-45139-07308-57583-25685 tcl slt th3 src

If a NOT NULL constraint is specified, then the column must have a default value other than NULL.

th3/req1/altertable01.test:156

/* IMP: R-29868-13536 */
# EVIDENCE-OF: R-29868-13536 If a NOT NULL constraint is specified, then
# the column must have a default value other than NULL.

R-13876-13274-06329-28290-52708-34927-05709-26395 tcl slt th3 src

If foreign key constraints are enabled and a column with a REFERENCES clause is added, the column must have a default value of NULL.

th3/req1/altertable01.test:166

/* IMP: R-13876-13274 */
# EVIDENCE-OF: R-13876-13274 If foreign key constraints are enabled and
# a column with a REFERENCES clause is added, the column must have a
# default value of NULL.

R-64634-29359-61184-64182-15828-53059-45249-47923 tcl slt th3 src

Note also that when adding a CHECK constraint, the CHECK constraint is not tested against preexisting rows of the table.

th3/req1/altertable01.test:181

/* IMP: R-64634-29359 */
# EVIDENCE-OF: R-64634-29359 Note also that when adding a CHECK
# constraint, the CHECK constraint is not tested against preexisting
# rows of the table.

R-41438-41245-47933-47570-18885-03208-62677-50789 tcl slt th3 src

This can result in a table that contains data that is in violation of the CHECK constraint.

th3/req1/altertable01.test:185

/* IMP: R-41438-41245 */
# EVIDENCE-OF: R-41438-41245 This can result in a table that contains
# data that is in violation of the CHECK constraint.