Deleting an Array
From InterBase
Go Up to Accessing Array Data
There are three ways to delete an array:
- Delete the row containing the array. You can use DSQL to execute a
DELETE
statement. - Replace the array with a different one, as described above. If an array column contains an array ID, and you modify the column to refer to a different array, the array referenced by the previously stored array ID will be deleted during the next garbage collection.
- Reset to
NULL
the column referring to the array. For example, use DSQL to execute a statement like the following, whereLANGUAGE_REQ
is an array column:
"UPDATE JOB SET LANGUAGE_REQ = NULL WHERE JOB_CODE = "SA12" AND JOB_GRADE = 10"
- The array referenced by the previously stored array ID will be deleted during the next garbage collection.