SqlTriggerAttribute.Target Property

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

The table to which the trigger applies.

Namespace:   Microsoft.SqlServer.Server
Assembly:  System.Data (in System.Data.dll)

public string Target { get; set; }

Property Value

Type: System.String

A String value representing the table name.

The Target property is required.

The following example specifies that the trigger is referenced by using the name trig_onpubinsert. The trigger is activated by adding new data (INSERT) to the table publishers.

public partial class Triggers
{
    [SqlTrigger(Name="trig_onpubinsert", Target="publishers", Event="FOR INSERT")]
    public static void PublishersInsertTrigger()
    {
        //...
    }
}

.NET Framework
Available since 2.0
Return to top
Show: