문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
|
번역
영문
|
Visual Studio 2017을 사용하는 것이 좋습니다.
Table.HasAfterTrigger 속성
SQL Server 2012
Gets the Boolean property value that specifies whether the table has any after triggers.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)] public bool HasAfterTrigger { get; }
속성 값
유형: System.BooleanA Boolean value that specifies whether there are any after triggers defined on the table.If True, at least one of the table's triggers is defined as an after trigger.If False (default), there are no after triggers defined on the table.
The following code example shows how to check each table in the AdventureWorks2012 database to see if it has any after triggers.
C#
Server srv = new Server("(local)"); Database db = srv.Databases["AdventureWorks2012"]; Foreach (Table tb in db.Tables) { Console.WriteLine("The " + tb.Name + " table has after triggers:" + tb.HasAfterTrigger.ToString()); }
Powershell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)") $db = New-Object Microsoft.SqlServer.Management.Smo.Database $db = $srv.Databases.Item("AdventureWorks2012") Foreach ($tb in $db.Tables) { Write-Host "The" $tb.Name "table has after triggers:" $tb.HasAfterTrigger }
표시: