|
Reset Cluster |
The RESET CLUSTER clustername statement resets all values
in the current cluster row to nulls and zeros. The row itself is not
removed, so it remains in place with its contents cleared.
collect cluster will skip the reset rows rows.
When used as
RESET CLUSTER clustername: ALL, the statement resets the
entire cluster to nulls and zeros, and all of its rows are deleted as
well.
A reset row is not reused when new rows are added later.
This statement also works with scalar clusters.
Summary table
| Operation | Effect | Reusability | Impact on Cluster |
|---|---|---|---|
RESET CLUSTER |
Sets values in the row to nulls and zeros | Row remains but is not reused | Keeps order intact |
|
Hide Description
|
|
|
Enter or modify the code below, and then click on RUN |
|
Looking for the full power of Sheerpower?
Check out the Sheerpower website. Free to download. Free to use. |
