• Article

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.