FILEPROPERTY (Transact-SQL)

Returns the specified file name property value when a file name and property name are specified.

Topic link iconTransact-SQL Syntax Conventions

Syntax

FILEPROPERTY ( file_name , property )

Arguments

  • file_name
    Is an expression that contains the name of the file associated with the current database for which to return property information. file_name is nchar(128).
  • property
    Is an expression that contains the name of the file property to return. property is varchar(128), and can be one of the following values.

    Value Description Value returned

    IsReadOnly

    Filegroup is read-only.

    1 = True

    0 = False

    NULL = Input is not valid.

    IsPrimaryFile

    File is the primary file.

    1 = True

    0 = False

    NULL = Input is not valid.

    IsLogFile

    File is a log file.

    1 = True

    0 = False

    NULL = Input is not valid.

    SpaceUsed

    Amount of space that is used by the specified file.

    Number of pages allocated in the file

Return Types

int

Remarks

file_name corresponds to the name column in the sys.master_files or sys.database_files catalog view.

Examples

The following example returns the setting for the IsPrimaryFile property for the AdventureWorks_Data file name in the AdventureWorks database.

USE AdventureWorks;
GO
SELECT FILEPROPERTY('AdventureWorks_Data', 'IsPrimaryFile')AS [Primary File];
GO

Here is the result set.

Primary File 
-------------
1
(1 row(s) affected)

See Also

Reference

FILEGROUPPROPERTY (Transact-SQL)
Metadata Functions (Transact-SQL)
sp_spaceused (Transact-SQL)
sys.database_files (Transact-SQL)
sys.master_files (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance