SymmetricKeys 属性
表示 SymmetricKey 对象的集合。每个 SymmetricKey 对象都表示对数据库定义的一个对称密钥。
命名空间： Microsoft.SqlServer.Management.Smo
程序集： Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）
语法
声明
<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, _
GetType(SymmetricKey))> _
Public ReadOnly Property SymmetricKeys As SymmetricKeyCollection
Get
用法
Dim instance As Database
Dim value As SymmetricKeyCollection
value = instance.SymmetricKeys
[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(SymmetricKey))]
public SymmetricKeyCollection SymmetricKeys { get; }
[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny,
typeof(SymmetricKey))]
public:
property SymmetricKeyCollection^ SymmetricKeys {
SymmetricKeyCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(SymmetricKey))>]
member SymmetricKeys : SymmetricKeyCollection
function get SymmetricKeys () : SymmetricKeyCollection
属性值
类型：Microsoft.SqlServer.Management.Smo. . :: . .SymmetricKeyCollection
一个 SymmetricKeyCollection 对象，该对象表示对数据库定义的所有对称密钥。
注释
Specific symmetric keys can be referenced by using this collection by specifying the name of the symmetric key. To add a new symmetric key to the collection, call the symmetric key constructor SymmetricKey, or its overload.
示例
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'Display all the symmetric keys in the database.
Dim sk As SymmetricKey
For Each sk In db.SymmetricKeys
Console.WriteLine(sk.Name)
Next
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
Foreach ($sk in $db.SymmetricKeys)
{
Write-Host $sk.Name
}