---
title: "Filestream and FileTable Functions (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "03/06/2017"
ms.prod: sql
ms.prod_service: "database-engine"
ms.reviewer: ""
ms.technology: system-objects
ms.topic: "language-reference"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "FileTables [SQL Server], system functions"
ms.assetid: 71f729df-d340-4cf9-9a6d-305fcb39b009
author: "rothja"
ms.author: "jroth"
---
# Filestream and FileTable Functions (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

  This section describes the system functions related to the FILESTREAM and FileTable features.  
  
 [FileTableRootPath (Transact-SQL)](../../relational-databases/system-functions/filetablerootpath-transact-sql.md)  
 Returns the root-level UNC path for a specific FileTable or for the current database.  
  
 [GetFileNamespacePath (Transact-SQL)](../../relational-databases/system-functions/getfilenamespacepath-transact-sql.md)  
 Returns the UNC path for a file or directory in a FileTable.  
  
 [GetPathLocator (Transact-SQL)](../../relational-databases/system-functions/getpathlocator-transact-sql.md)  
 Returns the path locator ID value for the specified file or directory in a FileTable.  
  
 [PathName (Transact-SQL)](../../relational-databases/system-functions/pathname-transact-sql.md)  
 Returns the path of a FILESTREAM binary large object (BLOB).  
  
 For more information about FileTables, see [FileTables (SQL Server)](../../relational-databases/blob/filetables-sql-server.md).