Classe PartitionScheme
The PartitionScheme object provides programmatic access to partition schemes.
Gerarchia di ereditarietà
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo.PartitionScheme
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute> _
Public NotInheritable Class PartitionScheme _
Inherits ScriptNameObjectBase _
Implements ISfcSupportsDesignMode, IDroppable, IAlterable, ICreatable, _
IScriptable
'Utilizzo
Dim instance As PartitionScheme
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute]
public sealed class PartitionScheme : ScriptNameObjectBase,
ISfcSupportsDesignMode, IDroppable, IAlterable, ICreatable, IScriptable
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute]
public ref class PartitionScheme sealed : public ScriptNameObjectBase,
ISfcSupportsDesignMode, IDroppable, IAlterable, ICreatable, IScriptable
[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute>]
type PartitionScheme =
class
inherit ScriptNameObjectBase
interface ISfcSupportsDesignMode
interface IDroppable
interface IAlterable
interface ICreatable
interface IScriptable
end
public final class PartitionScheme extends ScriptNameObjectBase implements ISfcSupportsDesignMode, IDroppable, IAlterable, ICreatable, IScriptable
Nel tipo PartitionScheme sono esposti i membri seguenti.
Costruttori
Nome | Descrizione | |
---|---|---|
PartitionScheme() | Initializes a new instance of the PartitionScheme class. | |
PartitionScheme(Database, String) | Initializes a new instance of the PartitionScheme class, and sets the name of the partition scheme and the database to which it belongs. |
In alto
Proprietà
Nome | Descrizione | |
---|---|---|
Events | Gets the events associated with the partition function. | |
ExtendedProperties | Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property defined on the PartitionScheme object. | |
FileGroups | Represents a collection of FileGroup objects. Each FileGroup object represents a filegroup defined on the database. | |
ID | Gets the zero-based ordinal of the PartitionScheme object, which specifies its position within the collection. | |
Name | Gets or sets a String which contains the name of the PartitionScheme. Esegue l'override di NamedSmoObject.Name. | |
NextUsedFileGroup | Gets or sets the name of the filegroup that has NEXT USED status. | |
Parent | Gets or sets the Database object that is the parent of the PartitionScheme object. | |
PartitionFunction | Gets or sets the name of the partition function used in this partition scheme. | |
Properties | Gets a collection of Property objects that represent the object properties. Ereditato da SqlSmoObject. | |
State | Gets the state of the referenced object. Ereditato da SmoObjectBase. | |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. Ereditato da SqlSmoObject. | |
UserData | Gets or sets user-defined data associated with the referenced object. Ereditato da SmoObjectBase. |
In alto
Metodi
Nome | Descrizione | |
---|---|---|
Alter | Updates any PartitionScheme object property changes on the instance of SQL Server. | |
Create | Creates a partition scheme on the instance of SQL Server as defined by the PartitionScheme object. | |
Discover | Discovers a list of type Object. Ereditato da SqlSmoObject. | |
Drop | Removes an existing partition scheme. | |
Equals | Ereditato da Object. | |
FormatSqlVariant | Formats an object as SqlVariant type. Ereditato da SqlSmoObject. | |
GetContextDB | Gets the context database that is associated with this object. Ereditato da SqlSmoObject. | |
GetDBName | Gets the database name that is associated with the object. Ereditato da SqlSmoObject. | |
GetHashCode | Ereditato da Object. | |
GetPropValue | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetPropValueOptional | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetServerObject | Gets the server of the SqlSmoObject object. Ereditato da SqlSmoObject. | |
GetType | Ereditato da Object. | |
Initialize() | Initializes the object and forces the properties be loaded. Ereditato da SqlSmoObject. | |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. Ereditato da SqlSmoObject. | |
IsObjectInitialized | Verifies whether the object has been initialized. Ereditato da SqlSmoObject. | |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. Ereditato da SqlSmoObject. | |
Refresh | Refreshes the state information for the PartitionScheme object. Esegue l'override di ScriptNameObjectBase.Refresh(). | |
ResetNextUsed | Resets the NEXT USED status of the partition scheme that has been marked as NEXT USED. | |
Script() | Generates a Transact-SQL script that can be used to re-create the partition scheme. | |
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the partition scheme as specified by the script options. | |
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. Ereditato da SqlSmoObject. | |
ToString | Returns a String that represents the referenced object. Ereditato da SqlSmoObject. | |
Validate | Validates the state of an object. Ereditato da SmoObjectBase. |
In alto
Eventi
Nome | Descrizione | |
---|---|---|
PropertyChanged | Represents the event that occurs when a property is changed. Ereditato da SqlSmoObject. | |
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. Ereditato da SqlSmoObject. |
In alto
Implementazioni esplicite dell'interfaccia
Nome | Descrizione | |
---|---|---|
IAlienObject.Discover | Discovers any dependencies. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. | |
IAlienObject.GetDomainRoot | Returns the root of the domain. Ereditato da SqlSmoObject. | |
IAlienObject.GetParent | Gets the parent of this object. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. | |
IAlienObject.GetPropertyType | Gets the type of the specified property. Ereditato da SqlSmoObject. | |
IAlienObject.GetPropertyValue | Gets the value of the specified property. Ereditato da SqlSmoObject. | |
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject. | |
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. Ereditato da SqlSmoObject. | |
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. Ereditato da SqlSmoObject. | |
IAlienObject.SetPropertyValue | Sets the property value. Ereditato da SqlSmoObject. | |
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. Ereditato da SqlSmoObject. | |
ISfcSupportsDesignMode.IsDesignMode | Gets a Boolean value that indicates whether the object supports design mode. Identificato solo a scopo informativo. Non supportato. Non è garantita la compatibilità con le versioni future. |
In alto
Osservazioni
Partition schemes define the physical structure that is used to partition tables and indexes across multiple file groups.
To get PartitionScheme object properties, users can be a member of the public fixed server role.
To set PartitionScheme object properties, users must use the ALTER statement to alter permission on the database or ALTER ANY DATASPACE for permissions on the server or be a member of the db_owner or db_ddladmin fixed database roles or sysadmin fixed server role.
To create or drop a partition scheme, users must use ALTER for permission on the database or ALTER ANY DATASPACE for permission on the server or be a member of the db_owner or db_ddladmin fixed database roles or a member of sysadmin fixed server role.
Thread Safety
Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.
Esempi
Utilizzo di filegroup e file per archiviare dati
Protezione dei thread
I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.
Vedere anche
Riferimento
Spazio dei nomi Microsoft.SqlServer.Management.Smo