Share via

UserDefinedFunction.DataType Property

  • Article

Gets or sets the return type for scalar functions.

This API is not CLS-compliant. 

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcReferenceAttribute(GetType(UserDefinedDataType), GetType(UserDefinedDataTypeResolver),  _
    "Resolve", )> _
<CLSCompliantAttribute(False)> _
<SfcReferenceAttribute(GetType(UserDefinedType), GetType(UserDefinedTypeResolver),  _
    "Resolve", )> _
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property DataType As DataType 
    Get 
    Set
'Usage
Dim instance As UserDefinedFunction 
Dim value As DataType 

value = instance.DataType

instance.DataType = value

[SfcReferenceAttribute(typeof(UserDefinedDataType), typeof(UserDefinedDataTypeResolver), 
    "Resolve", )]
[CLSCompliantAttribute(false)]
[SfcReferenceAttribute(typeof(UserDefinedType), typeof(UserDefinedTypeResolver), 
    "Resolve", )]
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public DataType DataType { get; set; }

[SfcReferenceAttribute(typeof(UserDefinedDataType), typeof(UserDefinedDataTypeResolver), 
    L"Resolve", )]
[CLSCompliantAttribute(false)]
[SfcReferenceAttribute(typeof(UserDefinedType), typeof(UserDefinedTypeResolver), 
    L"Resolve", )]
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property DataType^ DataType {
    DataType^ get ();
    void set (DataType^ value);
}

[<SfcReferenceAttribute(typeof(UserDefinedDataType), typeof(UserDefinedDataTypeResolver), 
    "Resolve", )>]
[<CLSCompliantAttribute(false)>]
[<SfcReferenceAttribute(typeof(UserDefinedType), typeof(UserDefinedTypeResolver), 
    "Resolve", )>]
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member DataType : DataType with get, set

function get DataType () : DataType 
function set DataType (value : DataType)

Property Value

Type: Microsoft.SqlServer.Management.Smo.DataType
A DataType system object value that specifies the data type of the function's return value.

Remarks

This property is null for nonscalar functions.

Examples

Setting Properties

See Also

Reference

UserDefinedFunction Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

User-Defined Functions (Database Engine)

CREATE FUNCTION (Transact-SQL)