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

# kinetica.DeleteRecordsRequest.Options

> kinetica.DeleteRecordsRequest.Options — Kinetica C# API

<div className="kinetica-doxygen">
  <div className="contents">
    <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsRequest#a83a89bd0f4348d3f470b1e06f3209727" title="Optional parameters.">DeleteRecordsRequest.options</a>. <a href="#details">More...</a></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Static Public Attributes</h2>
        </td>
      </tr>

      <tr className="memitem:afe7e686961f05de27f0917139c4c0cc9" id="r_afe7e686961f05de27f0917139c4c0cc9">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#afe7e686961f05de27f0917139c4c0cc9">GLOBAL\_EXPRESSION</a> = "global\_expression"</td>
      </tr>

      <tr className="memdesc:afe7e686961f05de27f0917139c4c0cc9">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">An optional global expression to reduce the search space of the <a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsRequest#aecd0c0f7c0ee31fc00ac48c1294535f5" title="A list of the actual predicates, one for each select; format should follow the guidelines provided he...">DeleteRecordsRequest.expressions</a>. <br /></td>
      </tr>

      <tr className="separator:afe7e686961f05de27f0917139c4c0cc9">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a4a820b0b7e7607a4017b9809f89a4b47" id="r_a4a820b0b7e7607a4017b9809f89a4b47">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a4a820b0b7e7607a4017b9809f89a4b47">RECORD\_ID</a> = "record\_id"</td>
      </tr>

      <tr className="memdesc:a4a820b0b7e7607a4017b9809f89a4b47">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">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="">Kinetica.getRecordsFromCollection</a> with the <span className="em">return\_record\_ids</span> option. <br /></td>
      </tr>

      <tr className="separator:a4a820b0b7e7607a4017b9809f89a4b47">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a0fd3a52d6ed96cd6028b6dda177d9542" id="r_a0fd3a52d6ed96cd6028b6dda177d9542">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a0fd3a52d6ed96cd6028b6dda177d9542">DELETE\_ALL\_RECORDS</a> = "delete\_all\_records"</td>
      </tr>

      <tr className="memdesc:a0fd3a52d6ed96cd6028b6dda177d9542">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If set to <a className="el" href="#a65671d1b5de7061925e5e0963b5c226d">TRUE</a>, all records in the table will be deleted. <br /></td>
      </tr>

      <tr className="separator:a0fd3a52d6ed96cd6028b6dda177d9542">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a65671d1b5de7061925e5e0963b5c226d" id="r_a65671d1b5de7061925e5e0963b5c226d">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a65671d1b5de7061925e5e0963b5c226d">TRUE</a> = "true"</td>
      </tr>

      <tr className="memdesc:a65671d1b5de7061925e5e0963b5c226d">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options" title="A set of string constants for the parameter DeleteRecordsRequest.options.">DeleteRecordsRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:a65671d1b5de7061925e5e0963b5c226d">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ae1121e75b0691e1b39344d553ebba6d6" id="r_ae1121e75b0691e1b39344d553ebba6d6">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ae1121e75b0691e1b39344d553ebba6d6">FALSE</a> = "false"</td>
      </tr>

      <tr className="memdesc:ae1121e75b0691e1b39344d553ebba6d6">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options" title="A set of string constants for the parameter DeleteRecordsRequest.options.">DeleteRecordsRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:ae1121e75b0691e1b39344d553ebba6d6">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <h2 className="groupheader">Detailed Description</h2>

    <div className="textblock">
      <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsRequest#a83a89bd0f4348d3f470b1e06f3209727" title="Optional parameters.">DeleteRecordsRequest.options</a>. </p>
      <p>Optional parameters.</p>
      <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source#l00030">30</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source">DeleteRecords.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#a0fd3a52d6ed96cd6028b6dda177d9542">◆ </a></span>DELETE\_ALL\_RECORDS</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.DeleteRecordsRequest.Options.DELETE\_ALL\_RECORDS = "delete\_all\_records"</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>If set to <a className="el" href="#a65671d1b5de7061925e5e0963b5c226d">TRUE</a>, all records in the table will be deleted. </p>
        <p>If set to <a className="el" href="#ae1121e75b0691e1b39344d553ebba6d6">FALSE</a>, then the option is effectively ignored. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a65671d1b5de7061925e5e0963b5c226d">TRUE</a> </li>
          <li> <a className="el" href="#ae1121e75b0691e1b39344d553ebba6d6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ae1121e75b0691e1b39344d553ebba6d6">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source#l00068">68</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source">DeleteRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ae1121e75b0691e1b39344d553ebba6d6">◆ </a></span>FALSE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.DeleteRecordsRequest.Options.FALSE = "false"</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options" title="A set of string constants for the parameter DeleteRecordsRequest.options.">DeleteRecordsRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source#l00076">76</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source">DeleteRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#afe7e686961f05de27f0917139c4c0cc9">◆ </a></span>GLOBAL\_EXPRESSION</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.DeleteRecordsRequest.Options.GLOBAL\_EXPRESSION = "global\_expression"</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>An optional global expression to reduce the search space of the <a className="el" href="/content/api/cs/classkinetica_1_1DeleteRecordsRequest#aecd0c0f7c0ee31fc00ac48c1294535f5" title="A list of the actual predicates, one for each select; format should follow the guidelines provided he...">DeleteRecordsRequest.expressions</a>. </p>
        <p>The default value is ''.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source#l00035">35</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source">DeleteRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a4a820b0b7e7607a4017b9809f89a4b47">◆ </a></span>RECORD\_ID</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.DeleteRecordsRequest.Options.RECORD\_ID = "record\_id"</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>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="">Kinetica.getRecordsFromCollection</a> with the <span className="em">return\_record\_ids</span> option. </p>
        <p>This option cannot be used to delete records from <a href="/content/concepts/tables/#replication" target="_top">replicated</a> tables.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source#l00045">45</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source">DeleteRecords.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a65671d1b5de7061925e5e0963b5c226d">◆ </a></span>TRUE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.DeleteRecordsRequest.Options.TRUE = "true"</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1DeleteRecordsRequest_1_1Options" title="A set of string constants for the parameter DeleteRecordsRequest.options.">DeleteRecordsRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source#l00072">72</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source">DeleteRecords.cs</a>.</p>
      </div>
    </div>

    <hr />

    The documentation for this struct was generated from the following files:

    <ul>
      <li>\_build/public-os\_ubuntu24.04-arch\_amd64-cc\_gcc\_13.3.0/install/Kinetica/Protocol/<a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2DeleteRecords_8cs_source">DeleteRecords.cs</a></li>
      <li>Kinetica/Protocol/<a className="el" href="/content/api/cs/Kinetica_2Protocol_2DeleteRecords_8cs_source">DeleteRecords.cs</a></li>
    </ul>
  </div>
</div>