---
title: "System Functions (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "11/02/2016"
ms.prod: "sql"
ms.prod_service: "database-engine"
ms.service: ""
ms.component: "system-functions"
ms.reviewer: ""
ms.suite: "sql"
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "language-reference"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "system stored functions [SQL Server]"
ms.assetid: 8ad860e7-e054-4186-80a2-03977e42531d
caps.latest.revision: 15
author: "rothja"
ms.author: "jroth"
manager: "craigg"
ms.workload: "On Demand"
---
# System Functions for Transact-SQL
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]

  [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] provides the following groups of system functions.  
  
## In This Section  
 [Always On Availability Groups Functions](../../relational-databases/system-functions/always-on-availability-groups-functions-transact-sql.md)  
 [Change Data Capture Functions](../../relational-databases/system-functions/change-data-capture-functions-transact-sql.md)  
 [Change Tracking Functions](../../relational-databases/system-functions/change-tracking-functions-transact-sql.md)  
 [Data Collector Functions](../../relational-databases/system-functions/data-collector-functions-transact-sql.md)  
 [Filestream and FileTable Functions](../../relational-databases/system-functions/filestream-and-filetable-functions-transact-sql.md)  
 [Managed Backup Functions](../../relational-databases/system-functions/managed-backup-functions-transact-sql.md)  
 [sys.fn_get_sql](../../relational-databases/system-functions/sys-fn-get-sql-transact-sql.md)  
 [sys.fn_MSxe_read_event_stream](../../relational-databases/system-functions/sys-fn-msxe-read-event-stream-transact-sql.md)  
 [sys.fn_stmt_sql_handle_from_sql_stmt](../../relational-databases/system-functions/sys-fn-stmt-sql-handle-from-sql-stmt-transact-sql.md)  
 [sys.fn_validate_plan_guide](../../relational-databases/system-functions/sys-fn-validate-plan-guide-transact-sql.md)  
 [sys.fn_xe_file_target_read_file](../../relational-databases/system-functions/sys-fn-xe-file-target-read-file-transact-sql.md)  
 [sys.fn_backup_file_snapshots](../../relational-databases/system-functions/sys-fn-db-backup-file-snapshots-transact-sql.md)  
 [Semantic Full-Text Search Functions](../../relational-databases/system-functions/full-text-search-and-semantic-search-functions-transact-sql.md)  
 [System Metadata Functions](../../relational-databases/system-functions/system-metadata-functions.md)  
 [System Security Functions](../../relational-databases/system-functions/system-security-functions.md)  
 [System Trace Functions](../../relational-databases/system-functions/system-trace-functions.md)