다음을 통해 공유

  • 아티클

Triggers 속성

ServerDdlTrigger 개체의 컬렉션을 나타냅니다. 각 ServerDdlTrigger 개체는 SQL Server 인스턴스에 정의된 서버 DDL(데이터 정의 언어) 트리거를 나타냅니다.

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

구문

‘선언
<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,  _
    GetType(ServerDdlTrigger))> _
Public ReadOnly Property Triggers As ServerDdlTriggerCollection
    Get
‘사용 방법
Dim instance As Server
Dim value As ServerDdlTriggerCollection

value = instance.Triggers

[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(ServerDdlTrigger))]
public ServerDdlTriggerCollection Triggers { get; }

[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny, 
    typeof(ServerDdlTrigger))]
public:
property ServerDdlTriggerCollection^ Triggers {
    ServerDdlTriggerCollection^ get ();
}

[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(ServerDdlTrigger))>]
member Triggers : ServerDdlTriggerCollection

function get Triggers () : ServerDdlTriggerCollection

속성 값

유형: Microsoft.SqlServer.Management.Smo. . :: . .ServerDdlTriggerCollection
SQL Server 인스턴스에 정의된 모든 서버 DDL(데이터 정의 언어) 트리거를 나타내는 ServerDdlTriggerCollection 개체입니다.

주의

Server DDL triggers are procedures that run in response to data definition events at the server level. For example, you can create a server DDL trigger that runs when any database is dropped.

예

Visual Basic

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Display the server DDL triggers.
Dim tr As ServerDdlTrigger
For Each tr In srv.Triggers
   Console.WriteLine(tr.Name)
Next

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
foreach ($tr in $srv.Triggers)
{
   Write-Host $tr.Name
}