Loading lesson path
Concept visual
Start at both ends
Return the database user name (will return the current user since no id is specified):
SELECT USER_NAME();The USER_NAME() function returns the database user name based on the specified id.
If no id is specified, this function will return the name of the current user.USER_NAME( id_number )
Description id_number Optional. The id number of a user in the database
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
Return the database user name with id 1:
SELECT USER_NAME(1);❮ SQL Server Functions