Membri FileGroup
The FileGroup object represents a SQL Server file group.
Il tipo FileGroup espone i membri seguenti.
Costruttori
Nome | Descrizione | |
---|---|---|
![]() |
FileGroup() () () () | Initializes a new instance of the FileGroup class. |
![]() |
FileGroup(Database, String) | Initializes a new instance of the FileGroup class on the specified database that has the specified name. |
![]() |
FileGroup(Database, String, Boolean) | Initializes a new instance of the FileGroup class on the specified database with the specified name. Optionally, enables a FILESTREAM file group to be created. |
In alto
Metodi
Nome | Descrizione | |
---|---|---|
![]() |
AddDatabaseContext | (Ereditato da SqlSmoObject). |
![]() |
Alter | Updates any property changes to the FileGroup object on the instance of SQL Server. |
![]() |
AlterImpl | (Ereditato da SqlSmoObject). |
![]() |
AlterImplFinish | (Ereditato da SqlSmoObject). |
![]() |
AlterImplInit | (Ereditato da SqlSmoObject). |
![]() |
AlterImplWorker | (Ereditato da SqlSmoObject). |
![]() |
BindDefaultImpl | (Ereditato da SqlSmoObject). |
![]() |
BindRuleImpl | (Ereditato da SqlSmoObject). |
![]() |
CheckCollation | (Ereditato da SqlSmoObject). |
![]() |
CheckFileGroup | Scans and tests the integrity of database pages maintained in operating system files that implement the file group. |
![]() |
CheckFileGroupDataOnly | Scans and tests the integrity of database pages that are used to maintain table data in operating system files that implement the file group. |
![]() |
CheckObjectState() () () () | Validates the state of the referenced object. (Ereditato da SqlSmoObject). |
![]() |
CheckObjectState(Boolean) | Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (Ereditato da SqlSmoObject). |
![]() |
CheckObjectStateImpl | (Ereditato da SqlSmoObject). |
![]() |
CheckVersion100 | (Ereditato da SqlSmoObject). |
![]() |
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (Ereditato da SqlSmoObject). |
![]() |
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (Ereditato da SqlSmoObject). |
![]() |
CheckVersion90 | Check the validity of the object on SQL Server 2005. (Ereditato da SqlSmoObject). |
![]() |
CheckVersionBelow90 | (Ereditato da SqlSmoObject). |
![]() |
CleanObject | (Ereditato da SqlSmoObject). |
![]() |
Create | Creates a new file group based on the FileGroup object. |
![]() |
CreateImpl | (Ereditato da SqlSmoObject). |
![]() |
CreateImplFinish | (Ereditato da SqlSmoObject). |
![]() |
CreateImplInit | (Ereditato da SqlSmoObject). |
![]() |
Discover | (Ereditato da SqlSmoObject). |
![]() |
Drop | Drops the file group from the database. |
![]() |
DropImpl | (Ereditato da SqlSmoObject). |
![]() |
DropImplWorker | (Ereditato da SqlSmoObject). |
![]() |
EnumObjects | Enumerates the system and user-defined tables, indexes, and statistics mechanisms stored within a file group. |
![]() |
EnumScriptImpl | (Ereditato da SqlSmoObject). |
![]() |
EnumScriptImplWorker | (Ereditato da SqlSmoObject). |
![]() |
Equals | (Ereditato da Object). |
![]() |
Finalize | (Ereditato da Object). |
![]() |
FormatSqlVariant | (Ereditato da SqlSmoObject). |
![]() |
GenerateDataSpaceFileStreamScript | (Ereditato da SqlSmoObject). |
![]() |
GenerateDataSpaceScript | (Ereditato da SqlSmoObject). |
![]() |
GetBindDefaultScript | (Ereditato da SqlSmoObject). |
![]() |
GetBindRuleScript | (Ereditato da SqlSmoObject). |
![]() |
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Ereditato da SqlSmoObject). |
![]() |
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Ereditato da SqlSmoObject). |
![]() |
GetDateTimeParameter | (Ereditato da SqlSmoObject). |
![]() |
GetDateTimeParameterAsInt | (Ereditato da SqlSmoObject). |
![]() |
GetDBName | Gets the database name that is associated with the object. (Ereditato da SqlSmoObject). |
![]() |
GetEnumParameter | (Ereditato da SqlSmoObject). |
![]() |
GetFragOptionString | (Ereditato da SqlSmoObject). |
![]() |
GetGuidParameter | (Ereditato da SqlSmoObject). |
![]() |
GetHashCode | (Ereditato da Object). |
![]() |
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Ereditato da SqlSmoObject). |
![]() |
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Ereditato da SqlSmoObject). |
![]() |
GetPropValue | (Ereditato da SqlSmoObject). |
![]() |
GetPropValueOptional | (Ereditato da SqlSmoObject). |
![]() |
GetPropValueOptionalAllowNull | (Ereditato da SqlSmoObject). |
![]() |
GetRealValue | (Ereditato da SqlSmoObject). |
![]() |
GetScriptingOptionsForCreate | (Ereditato da SqlSmoObject). |
![]() |
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (Ereditato da SqlSmoObject). |
![]() |
GetServerObject | (Ereditato da SqlSmoObject). |
![]() |
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (Ereditato da SqlSmoObject). |
![]() |
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Ereditato da SqlSmoObject). |
![]() |
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Ereditato da SqlSmoObject). |
![]() |
GetTimeSpanParameterAsInt | (Ereditato da SqlSmoObject). |
![]() |
GetType | (Ereditato da Object). |
![]() |
GetUrnRecursive(StringBuilder) | (Ereditato da SqlSmoObject). |
![]() |
GetUrnRecursive(StringBuilder, UrnIdOption) | (Ereditato da SqlSmoObject). |
![]() |
ImplInitialize | (Ereditato da SqlSmoObject). |
![]() |
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). |
![]() |
IsObjectDirty | Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (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). |
![]() |
IsVersion80SP3 | (Ereditato da SqlSmoObject). |
![]() |
MarkDropped | (Ereditato da SqlSmoObject). |
![]() |
MarkForDrop | Marks the file group to be dropped next time its parent Database object is altered by the Alter method. |
![]() |
MarkForDropImpl | (Ereditato da SqlSmoObject). |
![]() |
MemberwiseClone | (Ereditato da Object). |
![]() |
PostAlter | (Ereditato da SqlSmoObject). |
![]() |
PostCreate | (Ereditato da SqlSmoObject). |
![]() |
PostDrop | (Ereditato da SqlSmoObject). |
![]() |
Refresh | Refreshes the object and retrieves properties when the object is next accessed. (Ereditato da SqlSmoObject). |
![]() |
Rename | Renames the file group. |
![]() |
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Ereditato da NamedSmoObject). |
![]() |
RenameImplWorker | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Ereditato da NamedSmoObject). |
![]() |
ScriptAlter | (Ereditato da SqlSmoObject). |
![]() |
ScriptChangeOwner | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Ereditato da NamedSmoObject). |
![]() |
ScriptCreate | (Ereditato da SqlSmoObject). |
![]() |
ScriptDdl | (Ereditato da SqlSmoObject). |
![]() |
ScriptDrop | (Ereditato da SqlSmoObject). |
![]() |
ScriptImpl() () () () | (Ereditato da SqlSmoObject). |
![]() |
ScriptImpl(ScriptingOptions) | (Ereditato da SqlSmoObject). |
![]() |
ScriptImplWorker | (Ereditato da SqlSmoObject). |
![]() |
ScriptRename | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Ereditato da NamedSmoObject). |
![]() |
SetParentImpl | (Ereditato da SqlSmoObject). |
![]() |
ToString | Returns a String that represents the referenced object. (Ereditato da SqlSmoObject). |
![]() |
TouchImpl | (Ereditato da SqlSmoObject). |
![]() |
UnbindDefaultImpl | (Ereditato da SqlSmoObject). |
![]() |
UnbindRuleImpl | (Ereditato da SqlSmoObject). |
![]() |
Validate | (Ereditato da SmoObjectBase). |
In alto
Proprietà
Nome | Descrizione | |
---|---|---|
![]() |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Ereditato da SqlSmoObject). |
![]() |
Files | Represents a collection of DataFile objects. Each DataFile object represents a file belonging to the file group. |
![]() |
ID | Gets the ID value that uniquely identifies the file group. |
![]() |
IsDefault | Gets or sets the Boolean value that specifies whether the file group is the default file group for the database. |
![]() |
IsFileStream | Gets the Boolean value that specifies whether the file group is of type FILESTREAM. |
![]() |
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Ereditato da SqlSmoObject). |
![]() |
Name | Gets or sets the name of the object. (Ereditato da NamedSmoObject). |
![]() |
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (Ereditato da SqlSmoObject). |
![]() |
Parent | Gets or sets the parent Database object of the FileGroup object. |
![]() |
Properties | Gets a collection of Property objects that represent the object properties. (Ereditato da SqlSmoObject). |
![]() |
ReadOnly | Gets the Boolean value that specifies whether the file group is read-only. |
![]() |
ScalarResult | Gets the scalar result for the referenced object. (Ereditato da SqlSmoObject). |
![]() |
Size | Gets or sets the size of the file group in MB. |
![]() |
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
Eventi
Nome | Descrizione | |
---|---|---|
![]() |
PropertyChanged | (Ereditato da SqlSmoObject). |
![]() |
PropertyMetadataChanged | (Ereditato da SqlSmoObject). |
In alto
Implementazioni esplicite dell'interfaccia
Nome | Descrizione | |
---|---|---|
![]() ![]() |
IAlienObjectDiscover | (Ereditato da SqlSmoObject). |
![]() ![]() |
IAlienObjectGetParent | (Ereditato da SqlSmoObject). |
![]() ![]() |
IAlienObjectGetProperty | (Ereditato da SqlSmoObject). |
![]() ![]() |
ISfcPropertyProviderGetPropertySet | (Ereditato da SqlSmoObject). |
![]() ![]() |
IAlienObjectGetUrn | (Ereditato da SqlSmoObject). |
![]() ![]() |
IAlienObjectResolve | (Ereditato da SqlSmoObject). |
![]() ![]() |
IAlienObjectSetProperty | (Ereditato da SqlSmoObject). |
In alto