SQL Server/T-SQL Tutorial/User Role/USER NAME

USER_NAME Function returns the name of user logged into the database. The syntax for the USER_NAME function is as follows:

4>
5>
6> select USER_NAME()
7> GO
--------------------------------------------------------------------------------------------------------------------------------
dbo
(1 rows affected)
1>