• Article

DdlTriggerBase Class

The DdlTriggerBase is a base class that is inherited by the DatabaseDdlTrigger object. This represents a SQL Server database data definition language (DDL) trigger.

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

Syntax

'Declaration
Public MustInherit Class DdlTriggerBase _
    Inherits ScriptNameObjectBase _
    Implements ICreatable, IAlterable, IDroppable, IScriptable,  _
    ITextObject
'Usage
Dim instance As DdlTriggerBase

public abstract class DdlTriggerBase : ScriptNameObjectBase, 
    ICreatable, IAlterable, IDroppable, IScriptable, ITextObject

public ref class DdlTriggerBase abstract : public ScriptNameObjectBase, 
    ICreatable, IAlterable, IDroppable, IScriptable, ITextObject

[<AbstractClassAttribute>]
type DdlTriggerBase =  
    class
        inherit ScriptNameObjectBase
        interface ICreatable
        interface IAlterable
        interface IDroppable
        interface IScriptable
        interface ITextObject
    end

public abstract class DdlTriggerBase extends ScriptNameObjectBase implements ICreatable, IAlterable, IDroppable, IScriptable, ITextObject

Remarks

DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events.

SQL Server Management Objects (SMO) provides programmatic access to allow management of all DDL trigger functionality with the DatabaseDdlTrigger object and the ServerDdlTrigger object.

Database DDL triggers respond to events within the scope of the database and server DDL triggers respond to events within the scope of the SQL Server instance.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.