SQL Server: CURRENT_USER function

CURRENT_USER function in SQL Server

This SQL Server tutorial explains how to use the CURRENT_USER function in SQL Server (Transact-SQL) with syntax and examples.


In SQL Server (Transact-SQL), the CURRENT_USER functions returns the name of the current user in the SQL Server database.


The syntax for the CURRENT_USER function in SQL Servers (Transact-SQL) is:


Parameters or Arguments

There are no parameters or arguments for the CURRENT_USER function.


Applies To

The CURRENT_USER function can be used in the following versions of SQL Servers (Transact-SQL):

  • SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005


Let’s look at some SQL Server CURRENT_USER functions examples and explore how to use the CURRENT_USER function in SQL Servers (Transact-SQL).

For example:

Result: 'dbo'

This Post Has One Comment

Leave a Reply