DataFile.IsPrimaryFile Property
Gets the Boolean property value that specifies whether the data file is the primary file of the database.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone)> _
Public Property IsPrimaryFile As Boolean
Get
Set
'Usage
Dim instance As DataFile
Dim value As Boolean
value = instance.IsPrimaryFile
instance.IsPrimaryFile = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)]
public bool IsPrimaryFile { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone)]
public:
property bool IsPrimaryFile {
bool get ();
void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)>]
member IsPrimaryFile : bool with get, set
function get IsPrimaryFile () : boolean
function set IsPrimaryFile (value : boolean)
Property Value
Type: System.Boolean
A Boolean value that specifies whether the data file is the primary file or a secondary file.If True, the data file the primary file. Otherwise, False (default).
Remarks
The primary file has an .mdf file extension and secondary files have an .ndf file extension.
Examples
Using Filegroups and Files to Store Data
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace