SQLite Requirement Matrix Details
lang_altertable.html
Index Summary Markup Original
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:157
/* 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:167
/* 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-16727-13091-18593-02936-45365-35968-45386-40640 tcl slt th3 src
The column may not be GENERATED ALWAYS .
/* IMP: R-16727-13091 */
# EVIDENCE-OF: R-16727-13091 The column may not be GENERATED ALWAYS .
R-58318-35349-04006-21440-04924-16231-32271-20333 tcl slt th3 src
The DROP COLUMN syntax is used to remove an existing column from a table.
tcl/alterdropcol2.test:23 th3/cov1/altertable25.test:21
/* IMP: R-58318-35349 */
# EVIDENCE-OF: R-58318-35349 The DROP COLUMN syntax is used to remove an # existing column from a table.
R-44709-33024-54980-17199-17128-51759-15220-29599 tcl slt th3 src
The DROP COLUMN command removes the named column from the table, and rewrites its content to purge the data associated with that column.
th3/cov1/altertable25.test:24
/* IMP: R-44709-33024 */
# EVIDENCE-OF: R-44709-33024 The DROP COLUMN command removes the named # column from the table, and rewrites its content to purge the data # associated with that column.
R-24098-10282-28593-32391-22620-22460-46080-08998 tcl slt th3 src
The DROP COLUMN command only works if the column is not referenced by any other parts of the schema and is not a PRIMARY KEY and does not have a UNIQUE constraint.
/* IMP: R-24098-10282 */
# EVIDENCE-OF: R-24098-10282 The DROP COLUMN command only works if the # column is not referenced by any other parts of the schema and is not a # PRIMARY KEY and does not have a UNIQUE constraint.
R-52436-31752-34647-62444-09688-32062-53340-29522 tcl slt th3 src
The column is a PRIMARY KEY or part of one.
tcl/alterdropcol2.test:60 th3/cov1/altertable25.test:33
/* IMP: R-52436-31752 */
# EVIDENCE-OF: R-52436-31752 The column is a PRIMARY KEY or part of one.
R-43412-16016-07613-58418-19222-63413-27211-48074 tcl slt th3 src
The column has a UNIQUE constraint.
tcl/alterdropcol2.test:77 th3/cov1/altertable25.test:79
/* IMP: R-43412-16016 */
# EVIDENCE-OF: R-43412-16016 The column has a UNIQUE constraint.
R-46731-08965-36580-59849-15689-59530-23694-02071 tcl slt th3 src
The column is indexed.
tcl/alterdropcol2.test:113 tcl/alterdropcol2.test:94 th3/cov1/altertable25.test:87
/* IMP: R-46731-08965 */
# EVIDENCE-OF: R-46731-08965 The column is indexed.
R-36602-21087-51192-25883-57410-35458-57650-49197 tcl slt th3 src
The column is named in the WHERE clause of a partial index.
th3/cov1/altertable25.test:141
/* IMP: R-36602-21087 */
# EVIDENCE-OF: R-36602-21087 The column is named in the WHERE clause of # a partial index.
R-47838-03249-08993-49658-07257-31799-38437-20814 tcl slt th3 src
The column is named in a table or column CHECK constraint not associated with the column being dropped.
tcl/alterdropcol2.test:124 th3/cov1/altertable25.test:170
/* IMP: R-47838-03249 */
# EVIDENCE-OF: R-47838-03249 The column is named in a table or column # CHECK constraint not associated with the column being dropped.
R-55640-01652-03650-49788-46468-05074-56971-00383 tcl slt th3 src
The column is used in a foreign key constraint.
tcl/alterdropcol2.test:135 th3/cov1/altertable25.test:200
/* IMP: R-55640-01652 */
# EVIDENCE-OF: R-55640-01652 The column is used in a foreign key # constraint.
R-20795-39479-27238-02391-59931-28698-11385-12447 tcl slt th3 src
The column is used in the expression of a generated column.
tcl/alterdropcol2.test:146 th3/cov1/altertable25.test:111
/* IMP: R-20795-39479 */
# EVIDENCE-OF: R-20795-39479 The column is used in the expression of a # generated column.
R-01515-49025-64718-16819-52124-40826-60868-48014 tcl slt th3 src
The column appears in a trigger or view.
tcl/alterdropcol2.test:163 th3/cov1/altertable25.test:211
/* IMP: R-01515-49025 */
# EVIDENCE-OF: R-01515-49025 The column appears in a trigger or view.