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.
I’m honestly not sure if I am incorrectly interpreting the diagram or if it indeed does not specify that exact command pattern.