Table.HasUpdateTrigger 属性
Gets the Boolean property value that specifies whether the table has an update trigger.
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasUpdateTrigger As Boolean
Get
用法
Dim instance As Table
Dim value As Boolean
value = instance.HasUpdateTrigger
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool HasUpdateTrigger { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool HasUpdateTrigger {
bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member HasUpdateTrigger : bool
function get HasUpdateTrigger () : boolean
属性值
类型:System.Boolean
A Boolean value that specifies whether there is an update trigger defined on the table.If True, there is an update trigger defined on the table. Otherwise, False (default).
注释
An update trigger executes when a row of data is updated.
示例
The following code example shows how to list each table in the AdventureWorks2012 database with an update trigger.
C#
Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];
foreach (Table tb in db.Tables)
{
if (tb.HasUpdateTrigger == true)
{
Console.WriteLine("The " + tb.Name + " table has an update trigger");
}
}
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)
{
If ($tb.HasUpdateTrigger -eq $TRUE)
{
Write-Host "The" $tb.Name "table has an update trigger."
}
}
请参阅
参考
Microsoft.SqlServer.Management.Smo 命名空间