Trigger.ImplementationType Property

  • Article

Gets or sets the implementation type of the trigger.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property ImplementationType As ImplementationType 
    Get 
    Set
'Usage
Dim instance As Trigger 
Dim value As ImplementationType 

value = instance.ImplementationType

instance.ImplementationType = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public ImplementationType ImplementationType { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property ImplementationType ImplementationType {
    ImplementationType get ();
    void set (ImplementationType value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member ImplementationType : ImplementationType with get, set

function get ImplementationType () : ImplementationType 
function set ImplementationType (value : ImplementationType)

Property Value

Type: Microsoft.SqlServer.Management.Smo.ImplementationType
An ImplementationType object value that specifies the implementation type of the trigger.

Remarks

This property specifies whether the trigger is implemented with an SQL Server CLR type or with Transact-SQL. If the trigger is implemented with an SQL Server CLR type, values are required for the ExecutionContextPrincipal property, the AssemblyName property, the ClassName property, and the MethodName property.

Examples

Creating, Altering, and Removing Triggers

See Also

Reference

Trigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DML Triggers

CREATE TRIGGER (Transact-SQL)