Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
lang_altertable.html

Index Summary Markup Original


R-04338-23101-00276-58244-31553-31422-17859-30717 tcl slt th3 src

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

/* IMP: R-04338-23101 */
# EVIDENCE-OF: R-04338-23101 -- 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-44088-49603-17242-39121-62990-11734-14317-22918 tcl slt th3 src

Canonical usage: syntax/expr.html

/* IMP: R-44088-49603 */
# EVIDENCE-OF: R-44088-49603 -- syntax diagram expr

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-16509-55463-24556-39205-60952-38987-14623-40192 tcl slt th3 src

Canonical usage: syntax/select-stmt.html

/* IMP: R-16509-55463 */
# EVIDENCE-OF: R-16509-55463 -- 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-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-17878-35294-47697-18266-55769-35956-00477-22042 tcl slt th3 src

However, if there are any view definitions, or statements executed by triggers that refer to the table being renamed, these are not automatically modified to use the new table name.

th3/req1/altertable01.test:64

/* IMP: R-17878-35294 */
# EVIDENCE-OF: R-17878-35294 However, if there are any view definitions,
# or statements executed by triggers that refer to the table being
# renamed, these are not automatically modified to use the new table
# name.

R-40827-27357-46487-27198-26867-15174-62736-47681 tcl slt th3 src

If foreign key constraints are enabled when a table is renamed, then any REFERENCES clauses in any table (either the table being renamed or some other table) that refer to the table being renamed are modified to refer to the renamed table by its new name.

th3/req1/altertable01.test:90

/* IMP: R-40827-27357 */
# EVIDENCE-OF: R-40827-27357 If foreign key constraints are enabled when
# a table is renamed, then any REFERENCES clauses in any table (either
# the table being renamed or some other table) that refer to the table
# being renamed are modified to refer to the renamed table by its new
# name.

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:132

/* 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:135

/* 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:138

/* 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:158

/* 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:169

/* 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:187

/* 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:197

/* 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:212

/* 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:216

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