Documentation Source Text

Check-in [9b5947f2ee]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Comment:Fix a long-standing typo in the ALTER TABLE documentation.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 9b5947f2ee88d9c5c67c2120276dc29fad32e7921e961665951a905c362c802c
User & Date: drh 2018-09-06 20:36:53
Improvements to the RENAME COLUMN syntax diagram. check-in: c951c8c482 user: drh tags: trunk
Fix a long-standing typo in the ALTER TABLE documentation. check-in: 9b5947f2ee user: drh tags: trunk
Update the documentation to reflect the enhancements to ALTER TABLE. check-in: c3c04a7bb4 user: drh tags: trunk
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/

   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.