sql: apply PARTITION ALL BY when using ALTER PRIMARY KEY

[jseldess]

Jesse Seldess commented:

PR: https://github.com/cockroachdb/cockroach/pull/59178

From release notes:

PARTITION ALL BY statements will now apply for tables when using [ALTER PRIMARY KEY](../v21.1/alter-primary-key.html]. [#59178][#59178) {% comment %}doc{% endcomment %}

Jira Issue: DOC-950

[exalate-issue-sync[bot]]

Nick Vigilante (nickvigilante) commented: This requires an update to the SQL diagrams. I’m deferring this to after the 15th.

[exalate-issue-sync[bot]]

Nick Vigilante (nickvigilante) commented: Diagrams that need updating:

• ALTER PRIMARY KEY
• CREATE TABLE
• CREATE INDEX
• PARTITION BY