FileGroup 成員
The FileGroup object represents a SQL Server file group.
FileGroup 型別公開下列成員。
建構函式
名稱 | 描述 | |
---|---|---|
![]() |
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. |
頂端
方法
名稱 | 描述 | |
---|---|---|
![]() |
AddDatabaseContext | (繼承自 SqlSmoObject。) |
![]() |
Alter | Updates any property changes to the FileGroup object on the instance of SQL Server. |
![]() |
AlterImpl | (繼承自 SqlSmoObject。) |
![]() |
AlterImplFinish | (繼承自 SqlSmoObject。) |
![]() |
AlterImplInit | (繼承自 SqlSmoObject。) |
![]() |
AlterImplWorker | (繼承自 SqlSmoObject。) |
![]() |
BindDefaultImpl | (繼承自 SqlSmoObject。) |
![]() |
BindRuleImpl | (繼承自 SqlSmoObject。) |
![]() |
CheckCollation | (繼承自 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. (繼承自 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. (繼承自 SqlSmoObject。) |
![]() |
CheckObjectStateImpl | (繼承自 SqlSmoObject。) |
![]() |
CheckVersion100 | (繼承自 SqlSmoObject。) |
![]() |
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (繼承自 SqlSmoObject。) |
![]() |
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (繼承自 SqlSmoObject。) |
![]() |
CheckVersion90 | Check the validity of the object on SQL Server 2005. (繼承自 SqlSmoObject。) |
![]() |
CheckVersionBelow90 | (繼承自 SqlSmoObject。) |
![]() |
CleanObject | (繼承自 SqlSmoObject。) |
![]() |
Create | Creates a new file group based on the FileGroup object. |
![]() |
CreateImpl | (繼承自 SqlSmoObject。) |
![]() |
CreateImplFinish | (繼承自 SqlSmoObject。) |
![]() |
CreateImplInit | (繼承自 SqlSmoObject。) |
![]() |
Discover | (繼承自 SqlSmoObject。) |
![]() |
Drop | Drops the file group from the database. |
![]() |
DropImpl | (繼承自 SqlSmoObject。) |
![]() |
DropImplWorker | (繼承自 SqlSmoObject。) |
![]() |
EnumObjects | Enumerates the system and user-defined tables, indexes, and statistics mechanisms stored within a file group. |
![]() |
EnumScriptImpl | (繼承自 SqlSmoObject。) |
![]() |
EnumScriptImplWorker | (繼承自 SqlSmoObject。) |
![]() |
Equals | (繼承自 Object。) |
![]() |
Finalize | (繼承自 Object。) |
![]() |
FormatSqlVariant | (繼承自 SqlSmoObject。) |
![]() |
GenerateDataSpaceFileStreamScript | (繼承自 SqlSmoObject。) |
![]() |
GenerateDataSpaceScript | (繼承自 SqlSmoObject。) |
![]() |
GetBindDefaultScript | (繼承自 SqlSmoObject。) |
![]() |
GetBindRuleScript | (繼承自 SqlSmoObject。) |
![]() |
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (繼承自 SqlSmoObject。) |
![]() |
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (繼承自 SqlSmoObject。) |
![]() |
GetDateTimeParameter | (繼承自 SqlSmoObject。) |
![]() |
GetDateTimeParameterAsInt | (繼承自 SqlSmoObject。) |
![]() |
GetDBName | Gets the database name that is associated with the object. (繼承自 SqlSmoObject。) |
![]() |
GetEnumParameter | (繼承自 SqlSmoObject。) |
![]() |
GetFragOptionString | (繼承自 SqlSmoObject。) |
![]() |
GetGuidParameter | (繼承自 SqlSmoObject。) |
![]() |
GetHashCode | (繼承自 Object。) |
![]() |
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (繼承自 SqlSmoObject。) |
![]() |
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (繼承自 SqlSmoObject。) |
![]() |
GetPropValue | (繼承自 SqlSmoObject。) |
![]() |
GetPropValueOptional | (繼承自 SqlSmoObject。) |
![]() |
GetPropValueOptionalAllowNull | (繼承自 SqlSmoObject。) |
![]() |
GetRealValue | (繼承自 SqlSmoObject。) |
![]() |
GetScriptingOptionsForCreate | (繼承自 SqlSmoObject。) |
![]() |
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (繼承自 SqlSmoObject。) |
![]() |
GetServerObject | (繼承自 SqlSmoObject。) |
![]() |
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (繼承自 SqlSmoObject。) |
![]() |
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (繼承自 SqlSmoObject。) |
![]() |
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (繼承自 SqlSmoObject。) |
![]() |
GetTimeSpanParameterAsInt | (繼承自 SqlSmoObject。) |
![]() |
GetType | (繼承自 Object。) |
![]() |
GetUrnRecursive(StringBuilder) | (繼承自 SqlSmoObject。) |
![]() |
GetUrnRecursive(StringBuilder, UrnIdOption) | (繼承自 SqlSmoObject。) |
![]() |
ImplInitialize | (繼承自 SqlSmoObject。) |
![]() |
Initialize() () () () | Initializes the object and forces the properties be loaded. (繼承自 SqlSmoObject。) |
![]() |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (繼承自 SqlSmoObject。) |
![]() |
IsObjectDirty | Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (繼承自 SqlSmoObject。) |
![]() |
IsObjectInitialized | Verifies whether the object has been initialized. (繼承自 SqlSmoObject。) |
![]() |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (繼承自 SqlSmoObject。) |
![]() |
IsVersion80SP3 | (繼承自 SqlSmoObject。) |
![]() |
MarkDropped | (繼承自 SqlSmoObject。) |
![]() |
MarkForDrop | Marks the file group to be dropped next time its parent Database object is altered by the Alter method. |
![]() |
MarkForDropImpl | (繼承自 SqlSmoObject。) |
![]() |
MemberwiseClone | (繼承自 Object。) |
![]() |
PostAlter | (繼承自 SqlSmoObject。) |
![]() |
PostCreate | (繼承自 SqlSmoObject。) |
![]() |
PostDrop | (繼承自 SqlSmoObject。) |
![]() |
Refresh | Refreshes the object and retrieves properties when the object is next accessed. (繼承自 SqlSmoObject。) |
![]() |
Rename | Renames the file group. |
![]() |
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (繼承自 NamedSmoObject。) |
![]() |
RenameImplWorker | This method supports the SMO infrastructure and is not intended to be used directly from your code. (繼承自 NamedSmoObject。) |
![]() |
ScriptAlter | (繼承自 SqlSmoObject。) |
![]() |
ScriptChangeOwner | This method supports the SMO infrastructure and is not intended to be used directly from your code. (繼承自 NamedSmoObject。) |
![]() |
ScriptCreate | (繼承自 SqlSmoObject。) |
![]() |
ScriptDdl | (繼承自 SqlSmoObject。) |
![]() |
ScriptDrop | (繼承自 SqlSmoObject。) |
![]() |
ScriptImpl() () () () | (繼承自 SqlSmoObject。) |
![]() |
ScriptImpl(ScriptingOptions) | (繼承自 SqlSmoObject。) |
![]() |
ScriptImplWorker | (繼承自 SqlSmoObject。) |
![]() |
ScriptRename | This method supports the SMO infrastructure and is not intended to be used directly from your code. (繼承自 NamedSmoObject。) |
![]() |
SetParentImpl | (繼承自 SqlSmoObject。) |
![]() |
ToString | Returns a String that represents the referenced object. (繼承自 SqlSmoObject。) |
![]() |
TouchImpl | (繼承自 SqlSmoObject。) |
![]() |
UnbindDefaultImpl | (繼承自 SqlSmoObject。) |
![]() |
UnbindRuleImpl | (繼承自 SqlSmoObject。) |
![]() |
Validate | (繼承自 SmoObjectBase。) |
頂端
屬性
名稱 | 描述 | |
---|---|---|
![]() |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (繼承自 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. (繼承自 SqlSmoObject。) |
![]() |
Name | Gets or sets the name of the object. (繼承自 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. (繼承自 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. (繼承自 SqlSmoObject。) |
![]() |
ReadOnly | Gets the Boolean value that specifies whether the file group is read-only. |
![]() |
ScalarResult | Gets the scalar result for the referenced object. (繼承自 SqlSmoObject。) |
![]() |
Size | Gets or sets the size of the file group in MB. |
![]() |
State | Gets the state of the referenced object. (繼承自 SmoObjectBase。) |
![]() |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (繼承自 SqlSmoObject。) |
![]() |
UserData | Gets or sets user-defined data associated with the referenced object. (繼承自 SmoObjectBase。) |
頂端
明確繼承實作
名稱 | 描述 | |
---|---|---|
![]() ![]() |
IAlienObjectDiscover | (繼承自 SqlSmoObject。) |
![]() ![]() |
IAlienObjectGetParent | (繼承自 SqlSmoObject。) |
![]() ![]() |
IAlienObjectGetProperty | (繼承自 SqlSmoObject。) |
![]() ![]() |
ISfcPropertyProviderGetPropertySet | (繼承自 SqlSmoObject。) |
![]() ![]() |
IAlienObjectGetUrn | (繼承自 SqlSmoObject。) |
![]() ![]() |
IAlienObjectResolve | (繼承自 SqlSmoObject。) |
![]() ![]() |
IAlienObjectSetProperty | (繼承自 SqlSmoObject。) |
頂端