Export (0) Print
Expand All
Expand Minimize

USER_ID (Transact-SQL)

Returns the identification number for a database user.

Important noteImportant


Topic link iconTransact-SQL Syntax Conventions

USER_ID ( [ 'user' ] )


Is the username to be used. user is nchar. If a char value is specified, it is implicitly converted to nchar. The parentheses are required.

When user is omitted, the current user is assumed. When USER_ID is called after EXECUTE AS, USER_ID will return the ID of the impersonated context.

When a Windows principal that is not mapped to a specific database user accesses a database by way of membership in a group, USER_ID returns 0 (the ID of public). If such a principal creates an object without specifying a schema, SQL Server will create an implicit user and schema mapped to the Windows principal. The user created in such cases cannot be used to connect to the database. Calls to USER_ID by a Windows principal mapped to an implicit user will return the ID of the implicit user.


The following example returns the identification number for the AdventureWorks user Harold.

USE AdventureWorks;

Community Additions

© 2014 Microsoft