Condividi tramite


FileGroup Constructors

Definition

Overloads

FileGroup()
FileGroup(Database, String)
FileGroup(Database, String, FileGroupType)

Constructor that takes in the filegroup type.

This constructor handles the different version issues: - Katmai and before, only rows and partitions scheme file group types supported. - KJ and Denali, file stream file group type added. - Denali+, Memory optimized data file group type added.

FileGroup(Database, String, Boolean)

Constructor that takes a Boolean value indicating if the FileGroup is of type FileStream or not. In case isFileStream is true, FileStreamDataFileGroup type will be used otherwise RowsFileGroup will be used

FileGroup()

public FileGroup ();
Public Sub New ()

Applies to

FileGroup(Database, String)

public FileGroup (Microsoft.SqlServer.Management.Smo.Database database, string name);
new Microsoft.SqlServer.Management.Smo.FileGroup : Microsoft.SqlServer.Management.Smo.Database * string -> Microsoft.SqlServer.Management.Smo.FileGroup
Public Sub New (database As Database, name As String)

Parameters

database
Database
name
String

Applies to

FileGroup(Database, String, FileGroupType)

Constructor that takes in the filegroup type.

This constructor handles the different version issues: - Katmai and before, only rows and partitions scheme file group types supported. - KJ and Denali, file stream file group type added. - Denali+, Memory optimized data file group type added.

public FileGroup (Microsoft.SqlServer.Management.Smo.Database database, string name, Microsoft.SqlServer.Management.Smo.FileGroupType fileGroupType);
new Microsoft.SqlServer.Management.Smo.FileGroup : Microsoft.SqlServer.Management.Smo.Database * string * Microsoft.SqlServer.Management.Smo.FileGroupType -> Microsoft.SqlServer.Management.Smo.FileGroup
Public Sub New (database As Database, name As String, fileGroupType As FileGroupType)

Parameters

database
Database
name
String
fileGroupType
FileGroupType

Applies to

FileGroup(Database, String, Boolean)

Constructor that takes a Boolean value indicating if the FileGroup is of type FileStream or not. In case isFileStream is true, FileStreamDataFileGroup type will be used otherwise RowsFileGroup will be used

public FileGroup (Microsoft.SqlServer.Management.Smo.Database database, string name, bool isFileStream);
new Microsoft.SqlServer.Management.Smo.FileGroup : Microsoft.SqlServer.Management.Smo.Database * string * bool -> Microsoft.SqlServer.Management.Smo.FileGroup
Public Sub New (database As Database, name As String, isFileStream As Boolean)

Parameters

database
Database
name
String
isFileStream
Boolean

Remarks

This constructor is kept for consistency, it's recommended to specify FileGroupType when creating a FileGroup

Applies to