FileGroup FileGroup FileGroup Constructors

Definition

Overloads

FileGroup() FileGroup() FileGroup()

Initializes a new instance of the FileGroup class.

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

Initializes a new instance of the FileGroup class on the specified database that has the specified name.

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

Represents a SQL Server filegroup.

FileGroup(Database, String, Boolean) 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.

FileGroup() FileGroup() FileGroup()

Initializes a new instance of the FileGroup class.

public:
 FileGroup();
public FileGroup ();
Public Sub New ()

Examples

Working with Database Objects

Remarks

The default constructor initializes any fields to their default values.

See Also

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

Initializes a new instance of the FileGroup class on the specified database that has the specified name.

public:
 FileGroup(Microsoft::SqlServer::Management::Smo::Database ^ database, System::String ^ name);
public FileGroup (Microsoft.SqlServer.Management.Smo.Database database, string name);
Parameters
database
Database Database Database

A Database object value that represents the database that stores files in the file group.

name
String String String

A String value that represents the name of the file group.

Examples

Working with Database Objects

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

Represents a SQL Server filegroup.

public:
 FileGroup(Microsoft::SqlServer::Management::Smo::Database ^ database, System::String ^ name, Microsoft::SqlServer::Management::Smo::FileGroupType fileGroupType);
public FileGroup (Microsoft.SqlServer.Management.Smo.Database database, string name, Microsoft.SqlServer.Management.Smo.FileGroupType fileGroupType);
Parameters
database
Database Database Database

A Database object value that represents the database that stores files in the filegroup.

name
String String String

A String that represents the name of the file group.

fileGroupType
FileGroupType FileGroupType FileGroupType

A FileGroupType value that represents the type of filegroup in the database.

Remarks

For more information, see In-Memory OLTP (In-Memory Optimization).

FileGroup(Database, String, Boolean) 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.

public:
 FileGroup(Microsoft::SqlServer::Management::Smo::Database ^ database, System::String ^ name, bool isFileStream);
public FileGroup (Microsoft.SqlServer.Management.Smo.Database database, string name, bool isFileStream);
Parameters
database
Database Database Database

A Database object value that represents the database that stores files in the file group.

name
String String String

A String value that represents the name of the file group.

isFileStream
Boolean Boolean Boolean

A Boolean value. If (true) the instance will be initialized so that file groups of FILESTREAM type can be created.

Applies to