---
schema_version: "1"
id: 7ffe4b73649686311bba5de720410b9f86e27185b29142a1fb0ad49d1fe29665
title: ConnectApi.QuerySqlMetadataItem
collection: legacydeveloper
version: current
locale: en-us
portal_url: https://docs.salesforce.com/legacydeveloper/current/en-us/apexref/apex_connectapi_output_query_sql_metadata_item.md
canonical_url: https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_connectapi_output_query_sql_metadata_item.htm
source_site: developer.salesforce.com
content_type: documentation
content_hash: 7a50304bd20dc46e1149a00f80840a0d48d99d5858bf64ce5ec4f976293e075e
description: Represents the metadata associated with an SQL query output.
---
# ConnectApi.QuerySqlMetadataItem

Represents the metadata associated with an SQL query output.

<table class="featureTable sort_table" summary="">




          <thead class="thead sorted" align="left">
            <tr>
              <th class="featureTableHeader vertical-align-top " id="d1187194e46">Property Name</th>

              <th class="featureTableHeader vertical-align-top " id="d1187194e49">Type</th>

              <th class="featureTableHeader vertical-align-top " id="d1187194e52">Description</th>

              <th class="featureTableHeader vertical-align-top " id="d1187194e55">Available Version</th>

            </tr>

          </thead>

          <tbody class="tbody">
            <tr>
              <td class="entry" headers="d1187194e46" data-title="Property Name"><samp class="codeph apex_code">innerElement</samp></td>

              <td class="entry" headers="d1187194e49" data-title="Type"><a class="xref" href="#" title="Represents the metadata associated with an SQL query output."><samp class="codeph apex_code">ConnectApi.QuerySqlMetadataItem</samp></a></td>

              <td class="entry" headers="d1187194e52" data-title="Description"><span class="ph" id="innerElement"><a name="innerElement"><!-- --></a>Description of array fields.</span></td>

              <td class="entry" headers="d1187194e55" data-title="Available Version">62.0</td>

            </tr>

            <tr>
              <td class="entry" headers="d1187194e46" data-title="Property Name"><samp class="codeph apex_code">name</samp></td>

              <td class="entry" headers="d1187194e49" data-title="Type">String</td>

              <td class="entry" headers="d1187194e52" data-title="Description"><span class="ph" id="name"><a name="name"><!-- --></a>Name of the field.</span></td>

              <td class="entry" headers="d1187194e55" data-title="Available Version">62.0</td>

            </tr>

            <tr>
              <td class="entry" headers="d1187194e46" data-title="Property Name"><samp class="codeph apex_code">nullable</samp></td>

              <td class="entry" headers="d1187194e49" data-title="Type">Boolean</td>

              <td class="entry" headers="d1187194e52" data-title="Description"><span class="ph" id="nullable"><a name="nullable"><!-- --></a>Indicates if the field is nullable (<samp class="codeph apex_code"><span class="keyword">true</span></samp>) or not (<samp class="codeph apex_code"><span class="keyword">false</span></samp>).</span></td>

              <td class="entry" headers="d1187194e55" data-title="Available Version">62.0</td>

            </tr>

            <tr>
              <td class="entry" headers="d1187194e46" data-title="Property Name"><samp class="codeph apex_code">precision</samp></td>

              <td class="entry" headers="d1187194e49" data-title="Type">Integer</td>

              <td class="entry" headers="d1187194e52" data-title="Description"><span class="ph" id="precision"><a name="precision"><!-- --></a>Precision for numeric fields.</span></td>

              <td class="entry" headers="d1187194e55" data-title="Available Version">62.0</td>

            </tr>

            <tr>
              <td class="entry" headers="d1187194e46" data-title="Property Name"><samp class="codeph apex_code">scale</samp></td>

              <td class="entry" headers="d1187194e49" data-title="Type">Integer</td>

              <td class="entry" headers="d1187194e52" data-title="Description"><span class="ph" id="scale"><a name="scale"><!-- --></a>Scale for numeric fields.</span></td>

              <td class="entry" headers="d1187194e55" data-title="Available Version">62.0</td>

            </tr>

            <tr>
              <td class="entry" headers="d1187194e46" data-title="Property Name"><samp class="codeph apex_code">type</samp></td>

              <td class="entry" headers="d1187194e49" data-title="Type"><a class="xref" href="https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/connectAPI_enums.htm#TypeEnum"><samp class="codeph apex_code">TypeEnum</samp></a></td>

              <td class="entry" headers="d1187194e52" data-title="Description">Type of the SQL parameter.<ul class="ul bulletList">
                  <li class="li"><samp class="codeph nolang">ArrayOfX</samp></li>
                  <li class="li"><samp class="codeph nolang">BigInt</samp></li>
                  <li class="li"><samp class="codeph nolang">Bool</samp></li>
                  <li class="li"><samp class="codeph nolang">Char</samp></li>
                  <li class="li"><samp class="codeph nolang">Date</samp></li>
                  <li class="li"><samp class="codeph nolang">Double</samp></li>
                  <li class="li"><samp class="codeph nolang">Foat</samp></li>
                  <li class="li"><samp class="codeph nolang">Integer</samp></li>
                  <li class="li"><samp class="codeph nolang">Numeric</samp></li>
                  <li class="li"><samp class="codeph nolang">Oid</samp></li>
                  <li class="li"><samp class="codeph nolang">SmallInt</samp></li>
                  <li class="li"><samp class="codeph nolang">Time</samp></li>
                  <li class="li"><samp class="codeph nolang">Timestamp</samp></li>
                  <li class="li"><samp class="codeph nolang">TimestampTZ</samp></li>
                  <li class="li"><samp class="codeph nolang">Unspecified</samp></li>
                  <li class="li"><samp class="codeph nolang">Varchar</samp></li>
                </ul>
              </td>

              <td class="entry" headers="d1187194e55" data-title="Available Version">62.0</td>

            </tr>

          </tbody>

        </table>