PartitionSchemeParameters 屬性
表示 PartitionSchemeParameter 物件的集合。每個 PartitionSchemeParameter 物件代表在資料表上定義的資料分割配置參數。
命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny, _
GetType(PartitionSchemeParameter))> _
Public ReadOnly Property PartitionSchemeParameters As PartitionSchemeParameterCollection
Get
'用途
Dim instance As Table
Dim value As PartitionSchemeParameterCollection
value = instance.PartitionSchemeParameters
[SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny,
typeof(PartitionSchemeParameter))]
public PartitionSchemeParameterCollection PartitionSchemeParameters { get; }
[SfcObjectAttribute(SfcContainerRelationship::ChildContainer, SfcContainerCardinality::ZeroToAny,
typeof(PartitionSchemeParameter))]
public:
property PartitionSchemeParameterCollection^ PartitionSchemeParameters {
PartitionSchemeParameterCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.ZeroToAny,
typeof(PartitionSchemeParameter))>]
member PartitionSchemeParameters : PartitionSchemeParameterCollection
function get PartitionSchemeParameters () : PartitionSchemeParameterCollection
屬性值
型別:Microsoft.SqlServer.Management.Smo. . :: . .PartitionSchemeParameterCollection
表示在資料表上定義之所有資料分割配置參數的 PartitionSchemeParameter 物件。資料分割配置參數代表資料分割配置所在的檔案群組。
範例
The following code example prints the ID of each partition scheme parameter for each AdventureWorks2008R2 table, if any have been defined.
C#
Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2008R2"];
foreach (Table tb in db.Tables)
{
if (tb.PartitionSchemeParameters != null)
{
Foreach (PartitionSchemeParameter psp in tb.PartitionSchemeParameters)
{
Console.WriteLine(psp.ID);
}
}
else
{
Console.WriteLine("The " + tb.Name + " table has no defined partition scheme.");
}
}
Powershell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
Foreach ($tb in $db.Tables)
{
if ($tb.PartitionSchemeParameters -ne $NULL)
{
foreach ($psp in $tb.PartitionSchemeParameters)
{
Write-Host $pspi.ID
}
}
else
{
Write-Host "The" $tb.Name "table has no defined partition scheme."
}
}