DatabaseDdlTrigger Constructor (Database, String, DatabaseDdlTriggerEventSet, String)

Initializes a new instance of the DatabaseDdlTrigger class on the specified database with the specified name. The trigger responds to the specified event set and runs the specified batch.

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

Syntax

'Declaration
Public Sub New ( _
    parent As Database, _
    name As String, _
    events As DatabaseDdlTriggerEventSet, _
    textBody As String _
)

public DatabaseDdlTrigger (
    Database parent,
    string name,
    DatabaseDdlTriggerEventSet events,
    string textBody
)

public:
DatabaseDdlTrigger (
    Database^ parent, 
    String^ name, 
    DatabaseDdlTriggerEventSet^ events, 
    String^ textBody
)

public DatabaseDdlTrigger (
    Database parent, 
    String name, 
    DatabaseDdlTriggerEventSet events, 
    String textBody
)

public function DatabaseDdlTrigger (
    parent : Database, 
    name : String, 
    events : DatabaseDdlTriggerEventSet, 
    textBody : String
)

Parameter

• parent
  A Database object value that specifies the parent of the DatabaseDdlTrigger object.

• name
  A String value that specifies the name of the database data definition language (DDL) trigger.

• events
  A DatabaseDdlTriggerEventSet object that specifies the DDL events to which the trigger responds.

• textBody
  A String value that specifies the Transact-SQL batch statement that runs when the trigger has been raised.

Hinweise

Der Namespace, die Klasse oder das Element wird nur in der Version 2.0 von Microsoft .NET Framework unterstützt.

Beispiel

How to: Construct an Object in Visual Basic .NET

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Siehe auch

Verweis

DatabaseDdlTrigger Class
DatabaseDdlTrigger Members
Microsoft.SqlServer.Management.Smo Namespace

Andere Ressourcen

CREATE TRIGGER (Transact-SQL)
DDL-Trigger