> ## 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#a5b93b343ed8358190a2b0a9220f885b6" title="Optional parameters.">DeleteRecordsRequest.options</a>. <a href="#details">More...</a></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader">
            <div id="pub-static-attribs" />

            Static Public Attributes
          </h2>
        </td>
      </tr>

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

      <tr className="memdesc:a6ded14aebaa6fd1a8f624226bb92e9ab">
        <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#a9593962023e903613c2009b532c81bce" 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:a6ded14aebaa6fd1a8f624226bb92e9ab">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:aece56500bce174b6cbde147bba0fb8e6">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A record ID identifying a single record, obtained at the time of <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/insertrecordsraw#a292bd8df0c03cdf634e72208973515b3">insertion of the record</a> or by calling <a className="el" href="/content/api/cs/classkinetica_1_1GetRecordsFromCollectionRequest">Kinetica.getRecordsFromCollection</a> with the <span className="em">return\_record\_ids</span> option. <br /></td>
      </tr>

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

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

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

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

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

      <tr className="memdesc:a31340a466064a696bd4b6a7a2e050253">
        <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:a31340a466064a696bd4b6a7a2e050253">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:a5ee71172422d98914bd16439ca4f5806">
        <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:a5ee71172422d98914bd16439ca4f5806">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <div id="details" />

    <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#a5b93b343ed8358190a2b0a9220f885b6" title="Optional parameters.">DeleteRecordsRequest.options</a>. </p>
      <p>Optional parameters.</p>
      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs#L30">30</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs">DeleteRecords.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>

    <div id="a2575ac23fa074c764d233f6304ce1af5" />

    <h2 className="memtitle"><span className="permalink"><a href="#a2575ac23fa074c764d233f6304ce1af5">◆ </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="#a31340a466064a696bd4b6a7a2e050253">TRUE</a>, all records in the table will be deleted. </p>
        <p>If set to <a className="el" href="#a5ee71172422d98914bd16439ca4f5806">FALSE</a>, then the option is effectively ignored. Supported values:</p>

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

        <p>The default value is <a className="el" href="#a5ee71172422d98914bd16439ca4f5806">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs#L69">69</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs">DeleteRecords.cs</a>.</p>
      </div>
    </div>

    <div id="a5ee71172422d98914bd16439ca4f5806" />

    <h2 className="memtitle"><span className="permalink"><a href="#a5ee71172422d98914bd16439ca4f5806">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs#L77">77</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs">DeleteRecords.cs</a>.</p>
      </div>
    </div>

    <div id="a6ded14aebaa6fd1a8f624226bb92e9ab" />

    <h2 className="memtitle"><span className="permalink"><a href="#a6ded14aebaa6fd1a8f624226bb92e9ab">◆ </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#a9593962023e903613c2009b532c81bce" 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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs#L35">35</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs">DeleteRecords.cs</a>.</p>
      </div>
    </div>

    <div id="aece56500bce174b6cbde147bba0fb8e6" />

    <h2 className="memtitle"><span className="permalink"><a href="#aece56500bce174b6cbde147bba0fb8e6">◆ </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="/content/api/cs/classkinetica_1_1Kinetica/insertrecordsraw#a292bd8df0c03cdf634e72208973515b3">insertion of the record</a> or by calling <a className="el" href="/content/api/cs/classkinetica_1_1GetRecordsFromCollectionRequest">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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs#L46">46</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs">DeleteRecords.cs</a>.</p>
      </div>
    </div>

    <div id="a31340a466064a696bd4b6a7a2e050253" />

    <h2 className="memtitle"><span className="permalink"><a href="#a31340a466064a696bd4b6a7a2e050253">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs#L73">73</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs">DeleteRecords.cs</a>.</p>
      </div>
    </div>

    <hr />

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

    <ul>
      <li>Kinetica/Protocol/<a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/DeleteRecords.cs">DeleteRecords.cs</a></li>
    </ul>
  </div>
</div>


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