DataFile Properties

DataFile Properties

 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAvailableSpace

Gets the amount of available space in the data file in KB.

System_CAPS_pubpropertyBytesReadFromDisk

Gets the number of bytes read from disk.

System_CAPS_pubpropertyBytesWrittenToDisk

Gets the number of bytes written to disk.

System_CAPS_pubpropertyExecutionManager

(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyFileName

Gets or sets the data file name.

System_CAPS_pubpropertyGrowth

Gets or sets the growth increment for the data file in KB or percent.

System_CAPS_pubpropertyGrowthType

Gets or sets the growth type for the data file in kilobytes or percent.

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies the data file.

System_CAPS_pubpropertyIsOffline

Gets the Boolean property value that specifies whether the data file is offline or not.

System_CAPS_pubpropertyIsPrimaryFile

Gets the Boolean property value that specifies whether the data file is the primary file of the database.

System_CAPS_pubpropertyIsReadOnly

Gets the Boolean property value that specifies whether the data file is read-only or can be updated.

System_CAPS_pubpropertyIsReadOnlyMedia

Gets the Boolean property value that specifies whether the data file is stored on read-only media.

System_CAPS_pubpropertyIsSparse

Gets the Boolean value that specifies whether the file is a sparse file. Sparse files are used in database snapshots.

System_CAPS_pubpropertyMaxSize

Gets or set the maximum size to which the data file can grow in KB.

System_CAPS_pubpropertyName

Gets or sets the name of the object.(Inherited from NamedSmoObject.)

System_CAPS_pubpropertyNumberOfDiskReads

Gets the number of disk reads.

System_CAPS_pubpropertyNumberOfDiskWrites

Gets the number of disk writes.

System_CAPS_pubpropertyParent

Gets or sets the FileGroup object that is the parent of the DataFile object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertySize

Gets or sets the current size of the data file in KB.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUsedSpace

Gets the amount of used space in the data file in KB.

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyVolumeFreeSpace

Gets the volume free space in bytes.

Return to top
Show:
© 2016 Microsoft