*** DRAFT ***

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.

tcl/alterdropcol2.test:55

/* 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.