ArcGIS Pro 3.2 API Reference Guide
ArcGIS.Core.Data Namespace / SQLFunction Enumeration

In This Topic
    SQLFunction Enumeration
    In This Topic
    Specifies Datastore-dependent SQL function names.
    Syntax
    public enum SQLFunction : System.Enum, System.IComparable, System.IConvertible, System.IFormattable  
    Public Enum SQLFunction 
   Inherits System.Enum
   Implements System.IComparable, System.IConvertible, System.IFormattable
    Members
    MemberDescription
    Abs SQL ABS.
    ACos SQL ACOS.
    Ascii SQL ASCII.
    ASin SQL ASIN.
    ATan SQL ATAN.
    Avg SQL AVG.
    BitLength SQL BITLENGTH.
    Cast SQL CAST.
    Ceiling SQL CEILING.
    Char SQL CHAR.
    CharLength SQL CHARLENGTH.
    Coalesce SQL COALESCE.
    Concat SQL CONCAT.
    Convert SQL CONVERT.
    Cos SQL COS.
    Cosh SQL COSH.
    Count SQL COUNT.
    CurrentDate SQL CURRENTDATE.
    CurrentTime SQL CURRENTTIME.
    CurrentTimestamp SQL CURRENTTIMESTAMP.
    CurrentUser SQL CURRENTUSER.
    Extract SQL EXTRACT.
    Floor SQL FLOOR.
    Hex SQL HEX.
    Leading SQL LEADING.
    Ln SQL LN.
    Log SQL LOG.
    Log10 SQL LOG10.
    Lower SQL LOWER.
    Max SQL MAX.
    Min SQL MIN.
    Mod SQL MOD.
    NullIf SQL NULLIF.
    OctetLength SQL OCTETLENGTH.
    Position SQL POSITION.
    Power SQL POWER.
    Round SQL ROUND.
    Sign SQL SIGN.
    Sin SQL SIN.
    Sinh SQL SINH.
    SoundEx SQL SOUNDEX.
    StdDev SQL Standard Deviation.
    StdDevPop SQL STDDEV_POP.
    StdDevSamp SQL STDDEV_SAMP.
    Substring SQL SUBSTRING.
    SubstringBytes SQL SUBSTRING Bytes.
    Sum SQL SUM.
    Tan SQL TAN.
    Tanh SQL TANH.
    Trailing SQL TRAILING.
    Translate SQL TRANSLATE.
    Trim SQL TRIM.
    Truncate SQL TRUNCATE.
    Upper SQL UPPER.
    Var SQL VAR.
    VarPop SQL VAR_POP.
    VarSamp SQL VAR_SAMP.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             ArcGIS.Core.Data.SQLFunction

    Requirements

    Target Platforms: Windows 11, Windows 10

    ArcGIS Pro version: 3 or higher.
    See Also

    Reference

    ArcGIS.Core.Data Namespace

     

     

    ©2023 Esri Inc., All Rights Reserved. Generated on Wednesday, October 25, 2023

    Send feedback