> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# delete_records

### delete\_records

<ul>
  <li>
    delete\_records(\
    &#x20;table\_name: string,\
    &#x20;expressions: string\[],\
    &#x20;options?: Record\<string, string>,\
    &#x20;callback?: [GPUdbCallback](https://docs.kinetica.com/content/api/nodejs/types/GPUdbCallback.md),\
    ): Promise\<[DeleteRecordsResponse](https://docs.kinetica.com/content/api/nodejs/interfaces/DeleteRecordsResponse.md)>

    Deletes record(s) matching the provided criteria from the given table. The record selection criteria can either be one or more `expressions` (matching multiple records), a single record identified by record\_id options, or all records when using delete\_all\_records. Note that the three selection criteria are mutually exclusive. This operation cannot be run on a view. The operation is synchronous meaning that a response will not be available until the request is completely processed and all the matching records are deleted.

    #### Parameters

    <ul>
      <li>
        table\_name: string

        Name of the table from which to delete records, in \[schema\_name.]table\_name format, using standard name resolution rules. Must contain the name of an existing table; not applicable to views.
      </li>

      <li>
        expressions: string\[]

        A list of the actual predicates, one for each select; format should follow the guidelines provided here. Specifying one or more `expressions` is mutually exclusive to specifying record\_id in the `options`.
      </li>

      <li>
        `Optional`options: Record\<string, string>

        Optional parameters.
      </li>

      <li>
        `Optional`callback: [GPUdbCallback](https://docs.kinetica.com/content/api/nodejs/types/GPUdbCallback.md)

        Optional callback function
      </li>
    </ul>

    #### Returns Promise\<[DeleteRecordsResponse](https://docs.kinetica.com/content/api/nodejs/interfaces/DeleteRecordsResponse.md)>

    Promise\<Types.DeleteRecordsResponse> - Promise resolving to the response

    <ul>
      <li>Defined in [src/GPUdb.ts:7915](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/GPUdb.ts#L7915)</li>
    </ul>
  </li>
</ul>

### delete\_records\_request

<ul>
  <li>
    delete\_records\_request(\
    &#x20;request: [DeleteRecordsRequest](https://docs.kinetica.com/content/api/nodejs/interfaces/DeleteRecordsRequest.md),\
    &#x20;callback?: [GPUdbCallback](https://docs.kinetica.com/content/api/nodejs/types/GPUdbCallback.md),\
    ): Promise\<[DeleteRecordsResponse](https://docs.kinetica.com/content/api/nodejs/interfaces/DeleteRecordsResponse.md)>

    Deletes record(s) matching the provided criteria from the given table. The record selection criteria can either be one or more `expressions` (matching multiple records), a single record identified by record\_id options, or all records when using delete\_all\_records. Note that the three selection criteria are mutually exclusive. This operation cannot be run on a view. The operation is synchronous meaning that a response will not be available until the request is completely processed and all the matching records are deleted.

    #### Parameters

    <ul>
      <li>
        request: [DeleteRecordsRequest](https://docs.kinetica.com/content/api/nodejs/interfaces/DeleteRecordsRequest.md)

        Request object containing the parameters for the operation
      </li>

      <li>
        `Optional`callback: [GPUdbCallback](https://docs.kinetica.com/content/api/nodejs/types/GPUdbCallback.md)

        Optional callback function
      </li>
    </ul>

    #### Returns Promise\<[DeleteRecordsResponse](https://docs.kinetica.com/content/api/nodejs/interfaces/DeleteRecordsResponse.md)>

    Promise\<Types.DeleteRecordsResponse> - Promise resolving to the response

    <ul>
      <li>Defined in [src/GPUdb.ts:7883](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/GPUdb.ts#L7883)</li>
    </ul>
  </li>
</ul>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.