> ## 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.

# deleteRecords

<div className="kinetica-doxygen">
  <div id="aa9a90dadf56669a4883a44c9553e5995" />

  <h2 className="memtitle"><span className="permalink"><a href="#aa9a90dadf56669a4883a44c9553e5995">◆ </a></span>deleteRecords() <span className="overload">\[1/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname"><a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsResponse">DeleteRecordsResponse</a> kinetica.Kinetica.deleteRecords </td>
                <td>(</td>
                <td className="paramtype"><a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsRequest">DeleteRecordsRequest</a></td>
                <td className="paramname"><span className="paramname"><span className="em">request\_</span></span></td>
                <td>)</td>

                <td />
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Deletes record(s) matching the provided criteria from the given table. </p>
      <p>The record selection criteria can either be one or more <a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsRequest#a9593962023e903613c2009b532c81bce">expressions</a> (matching multiple records), a single record identified by <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#aece56500bce174b6cbde147bba0fb8e6">RECORD\_ID</a> options, or all records when using <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a2575ac23fa074c764d233f6304ce1af5">DELETE\_ALL\_RECORDS</a>. 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.</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_</td>
              <td>Request object containing the parameters for the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Response object containing the result of the operation. </div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L32022">32022</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="ad96ad05426e29781136d6a7d0dcc2186" />

  <h2 className="memtitle"><span className="permalink"><a href="#ad96ad05426e29781136d6a7d0dcc2186">◆ </a></span>deleteRecords() <span className="overload">\[2/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname"><a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsResponse">DeleteRecordsResponse</a> kinetica.Kinetica.deleteRecords </td>
                <td>(</td>
                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">table\_name</span></span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">IList\< string ></td>
                <td className="paramname"><span className="paramname"><span className="em">expressions</span></span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">IDictionary\< string, string ></td>
                <td className="paramname"><span className="paramname"><span className="em">options</span></span><span className="paramdefsep"> = </span><span className="paramdefval">null</span> )</td>
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Deletes record(s) matching the provided criteria from the given table. </p>
      <p>The record selection criteria can either be one or more <span className="em">expressions</span> (matching multiple records), a single record identified by <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#aece56500bce174b6cbde147bba0fb8e6">RECORD\_ID</a> options, or all records when using <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a2575ac23fa074c764d233f6304ce1af5">DELETE\_ALL\_RECORDS</a>. 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.</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">table\_name</td>
              <td>Name of the table from which to delete records, in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a>. Must contain the name of an existing table; not applicable to views.</td>
            </tr>

            <tr>
              <td className="paramname">expressions</td>
              <td>A list of the actual predicates, one for each select; format should follow the guidelines provided <a href="/content/concepts/expressions/" target="_top">here</a>. Specifying one or more <span className="em">expressions</span> is mutually exclusive to specifying <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#aece56500bce174b6cbde147bba0fb8e6">RECORD\_ID</a> in the <span className="em">options</span> .</td>
            </tr>

            <tr>
              <td className="paramname">options</td>

              <td>
                Optional parameters.

                <ul>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a6ded14aebaa6fd1a8f624226bb92e9ab">GLOBAL\_EXPRESSION</a>: An optional global expression to reduce the search space of the <span className="em">expressions</span> . The default value is ''. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#aece56500bce174b6cbde147bba0fb8e6">RECORD\_ID</a>: A record ID identifying a single record, obtained at the time of <a className="el" href="">insertion of the record</a> or by calling <a className="el" href="">getRecordsFromCollection</a> with the <span className="em">return\_record\_ids</span> option. This option cannot be used to delete records from <a href="/content/concepts/tables/#replication" target="_top">replicated</a> tables. </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a2575ac23fa074c764d233f6304ce1af5">DELETE\_ALL\_RECORDS</a>: If set to <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a31340a466064a696bd4b6a7a2e050253">TRUE</a>, all records in the table will be deleted. If set to <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a5ee71172422d98914bd16439ca4f5806">FALSE</a>, then the option is effectively ignored. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a31340a466064a696bd4b6a7a2e050253">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a5ee71172422d98914bd16439ca4f5806">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a5ee71172422d98914bd16439ca4f5806">FALSE</a>.
                  </li>
                </ul>

                The default value is an empty Dictionary.
              </td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Response object containing the result of the operation. </div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L32136">32136</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="a9981133ddea1628bbc6db65f99779040" />

  <h2 className="memtitle"><span className="permalink"><a href="#a9981133ddea1628bbc6db65f99779040">◆ </a></span>DeleteRecordsAsync() <span className="overload">\[1/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname">async System.Threading.Tasks.Task\< <a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsResponse">DeleteRecordsResponse</a> > kinetica.Kinetica.DeleteRecordsAsync </td>
                <td>(</td>
                <td className="paramtype"><a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsRequest">DeleteRecordsRequest</a></td>
                <td className="paramname"><span className="paramname"><span className="em">request\_</span></span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">System.Threading.CancellationToken</td>
                <td className="paramname"><span className="paramname"><span className="em">cancellationToken</span></span><span className="paramdefsep"> = </span><span className="paramdefval">default</span> )</td>
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Deletes record(s) matching the provided criteria from the given table. </p>
      <p>(async) </p>
      <p>The record selection criteria can either be one or more <a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsRequest#a9593962023e903613c2009b532c81bce">expressions</a> (matching multiple records), a single record identified by <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#aece56500bce174b6cbde147bba0fb8e6">RECORD\_ID</a> options, or all records when using <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a2575ac23fa074c764d233f6304ce1af5">DELETE\_ALL\_RECORDS</a>. 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.</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_</td>
              <td>Request object containing the parameters for the operation.</td>
            </tr>

            <tr>
              <td className="paramname">cancellationToken</td>
              <td>Cancellation token to cancel the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Task that returns the response object containing the result of the operation.</div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L32049">32049</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="a2603131e310ff67b962611876aaad5ee" />

  <h2 className="memtitle"><span className="permalink"><a href="#a2603131e310ff67b962611876aaad5ee">◆ </a></span>DeleteRecordsAsync() <span className="overload">\[2/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname">async System.Threading.Tasks.Task\< <a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsResponse">DeleteRecordsResponse</a> > kinetica.Kinetica.DeleteRecordsAsync </td>
                <td>(</td>
                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">table\_name</span></span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">IList\< string ></td>
                <td className="paramname"><span className="paramname"><span className="em">expressions</span></span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">IDictionary\< string, string ></td>
                <td className="paramname"><span className="paramname"><span className="em">options</span></span><span className="paramdefsep"> = </span><span className="paramdefval">null</span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">System.Threading.CancellationToken</td>
                <td className="paramname"><span className="paramname"><span className="em">cancellationToken</span></span><span className="paramdefsep"> = </span><span className="paramdefval">default</span> )</td>
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Deletes record(s) matching the provided criteria from the given table. </p>
      <p>(async) </p>
      <p>The record selection criteria can either be one or more <span className="em">expressions</span> (matching multiple records), a single record identified by <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#aece56500bce174b6cbde147bba0fb8e6">RECORD\_ID</a> options, or all records when using <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a2575ac23fa074c764d233f6304ce1af5">DELETE\_ALL\_RECORDS</a>. 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.</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">table\_name</td>
              <td>Name of the table from which to delete records, in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a>. Must contain the name of an existing table; not applicable to views.</td>
            </tr>

            <tr>
              <td className="paramname">expressions</td>
              <td>A list of the actual predicates, one for each select; format should follow the guidelines provided <a href="/content/concepts/expressions/" target="_top">here</a>. Specifying one or more <span className="em">expressions</span> is mutually exclusive to specifying <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#aece56500bce174b6cbde147bba0fb8e6">RECORD\_ID</a> in the <span className="em">options</span> .</td>
            </tr>

            <tr>
              <td className="paramname">options</td>

              <td>
                Optional parameters.

                <ul>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a6ded14aebaa6fd1a8f624226bb92e9ab">GLOBAL\_EXPRESSION</a>: An optional global expression to reduce the search space of the <span className="em">expressions</span> . The default value is ''. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#aece56500bce174b6cbde147bba0fb8e6">RECORD\_ID</a>: A record ID identifying a single record, obtained at the time of <a className="el" href="">insertion of the record</a> or by calling <a className="el" href="">getRecordsFromCollection</a> with the <span className="em">return\_record\_ids</span> option. This option cannot be used to delete records from <a href="/content/concepts/tables/#replication" target="_top">replicated</a> tables. </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a2575ac23fa074c764d233f6304ce1af5">DELETE\_ALL\_RECORDS</a>: If set to <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a31340a466064a696bd4b6a7a2e050253">TRUE</a>, all records in the table will be deleted. If set to <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a5ee71172422d98914bd16439ca4f5806">FALSE</a>, then the option is effectively ignored. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a31340a466064a696bd4b6a7a2e050253">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a5ee71172422d98914bd16439ca4f5806">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options#a5ee71172422d98914bd16439ca4f5806">FALSE</a>.
                  </li>
                </ul>

                The default value is an empty Dictionary.
              </td>
            </tr>

            <tr>
              <td className="paramname">cancellationToken</td>
              <td>Cancellation token to cancel the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Task that returns the response object containing the result of the operation.</div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L32224">32224</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>
</div>