다음을 통해 공유

  • 아티클

DatabaseDdlTrigger 클래스

The DatabaseDdlTrigger object represents a SQL Server database data definition language (DDL) trigger.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo.dll의 Microsoft.SqlServer.Smo

구문

‘선언
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)> _
<SfcElementTypeAttribute("DdlTrigger")> _
Public NotInheritable Class DatabaseDdlTrigger _
    Inherits DdlTriggerBase _
    Implements IExtendedProperties
‘사용 방법
Dim instance As DatabaseDdlTrigger

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)]
[SfcElementTypeAttribute("DdlTrigger")]
public sealed class DatabaseDdlTrigger : DdlTriggerBase, 
    IExtendedProperties

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute(PhysicalFacetOptions::ReadOnly)]
[SfcElementTypeAttribute(L"DdlTrigger")]
public ref class DatabaseDdlTrigger sealed : public DdlTriggerBase, 
    IExtendedProperties

[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)>]
[<SfcElementTypeAttribute("DdlTrigger")>]
type DatabaseDdlTrigger =  
    class
        inherit DdlTriggerBase
        interface IExtendedProperties
    end

public final class DatabaseDdlTrigger extends DdlTriggerBase implements IExtendedProperties

주의

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

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.

To get DatabaseDdlTrigger object properties, users can be a member of the public fixed server role.

To set DatabaseDdlTrigger object properties, users must have ALTER ANY DATABASE DDL TRIGGER permission on the database.

To create a DDL trigger, users must have ALTER ANY DATABASE DDL TRIGGER permission on the database.

To drop a DDL trigger, users must have ALTER ANY DATABASE DDL TRIGGER permission on the database.

To enable or disable the DDL trigger, users must have ALTER ANY DATABASE DDL TRIGGER permission on the database.

Thread Safety

이 유형의 모든 public static(Microsoft Visual Basic의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

스레드로부터의 안전성

이 형식의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.