System Functions for Transact-SQL

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server provides the following groups of system functions.

In This Section

Always On Availability Groups Functions
Change Data Capture Functions
Change Tracking Functions
Data Collector Functions
Filestream and FileTable Functions
Managed Backup Functions
sys.fn_get_sql
sys.fn_MSxe_read_event_stream
sys.fn_stmt_sql_handle_from_sql_stmt
sys.fn_validate_plan_guide
sys.fn_xe_file_target_read_file
sys.fn_backup_file_snapshots
Semantic Full-Text Search Functions
System Metadata Functions
System Security Functions
System Trace Functions