DELETE primary command
The DELETE primary command deletes rows from the data being edited.
Syntax
- ALL
- Causes the DELETE command to delete all rows (or all excluded
or non-excluded rows) within the specified range of rows (or within
the entire table, if you do not specify a range).
If you do not specify the ALL parameter, then the DELETE command deletes only the first row (or only the first excluded or non-excluded row) within the specified range.
- EX
- Excluded rows only.
- NX
- Non-excluded rows only.
- X
- Same as EX.
- label1
- Label identifying the start of a range of rows. The label must start with a period (.) followed by one to four alphabetic characters (no numeric or special characters). Labels starting with the letter “Z” indicate an editor-assigned label.
- label2
- Label identifying the end of a range of rows. The label must start with a period (.) followed by one to four alphabetic characters (no numeric or special characters). Labels starting with the letter “Z” indicate an editor-assigned label.