Documentation Source Text

Check-in [f995368f57]
Login

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

Overview
Comment:Update the ALTER TABLE bubble diagram to show the RENAME COLUMN syntax.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:f995368f571021df9048f1094779f97318a5cd8926dcea5303f876362d956c8d
User & Date: drh 2018-09-06 20:05:53
Context
2018-09-06
20:34
Update the documentation to reflect the enhancements to ALTER TABLE. check-in: c3c04a7bb4 user: drh tags: trunk
20:05
Update the ALTER TABLE bubble diagram to show the RENAME COLUMN syntax. check-in: f995368f57 user: drh tags: trunk
20:02
Merge documentation fixes from the 3.24.0 release branch. check-in: 4235bb053e user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to art/syntax/alter-table-stmt.gif.

cannot compute difference between binary files

Changes to art/syntax/bubble-generator-data.tcl.

47
48
49
50
51
52
53

54
55
56
57
58
59
60
      }
  }
  alter-table-stmt {
    rightstack
       {line ALTER TABLE {optx /schema-name .} /table-name}
       {tailbranch
          {line RENAME TO /new-table-name}

          {line ADD {optx COLUMN} column-def}
       }
  }
  analyze-stmt {
     line ANALYZE {or nil /schema-name /table-or-index-name
                    {line /schema-name . /table-or-index-name}}
  }







>







47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
      }
  }
  alter-table-stmt {
    rightstack
       {line ALTER TABLE {optx /schema-name .} /table-name}
       {tailbranch
          {line RENAME TO /new-table-name}
          {line RENAME {optx COLUMN} /old-column-name TO /new-column-name}
          {line ADD {optx COLUMN} column-def}
       }
  }
  analyze-stmt {
     line ANALYZE {or nil /schema-name /table-or-index-name
                    {line /schema-name . /table-or-index-name}}
  }