Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a long-standing typo in the ALTER TABLE documentation. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
9b5947f2ee88d9c5c67c2120276dc29f |
| User & Date: | drh 2018-09-06 20:36:53 |
Context
|
2018-09-06
| ||
| 21:37 | Improvements to the RENAME COLUMN syntax diagram. check-in: c951c8c482 user: drh tags: trunk | |
| 20:36 | Fix a long-standing typo in the ALTER TABLE documentation. check-in: 9b5947f2ee user: drh tags: trunk | |
| 20:34 | Update the documentation to reflect the enhancements to ALTER TABLE. check-in: c3c04a7bb4 user: drh tags: trunk | |
Changes
Changes to pages/lang.in.
275 275 <li><p> If the change to table X also affects other tables or indexes or 276 276 triggers are views within schema, then run [UPDATE] statements to modify 277 277 those other tables indexes and views too. For example, if the name of 278 278 a column changes, all FOREIGN KEY constraints, triggers, indexes, and 279 279 views that refer to that column must be modified. 280 280 <p><em>Caution:</em> Once again, making changes to the sqlite_master 281 281 table like this will render the database corrupt and unreadable if the 282 -change contains an error. Carefully test of this entire procedure 282 +change contains an error. Carefully test this entire procedure 283 283 on a separate test database prior to using it on 284 284 a database containing important data and/or make backup copies of 285 285 important databases prior to running this procedure. 286 286 287 287 <li><p> Increment the schema version number using 288 288 [PRAGMA schema_version | PRAGMA schema_version=X] where X is one 289 289 more than the old schema version number found in step 2 above.