Difficulty reading ALTER TABLE diagram

Hello, I’ve recently stared at the ALTER TABLE diagram trying to figure out the syntax for updating a column’s default value (without specifying a constraint name), but was unable to and had to look it up on Google instead, which turned out to be ALTER TABLE table ALTER COLUMN column SET DEFAULT value;, but I can’t seem to be able to make that out from the diagram, it doesn’t seem to match…

If I get down to ALTER COLUMN, it seems to have some required fields which I didn’t have to specify, so I’m quite confused.
image

I’m honestly not sure if I am incorrectly interpreting the diagram or if it indeed does not specify that exact command pattern.

It looks like SET DEFAULT is missing in the diagram. Can you file a docs issue on GitHub - yugabyte/yugabyte-db: YugabyteDB - the cloud native distributed SQL database for mission-critical applications.?

Nevermind, see Add alter column actions by premkumr · Pull Request #25769 · yugabyte/yugabyte-db · GitHub

1 Like