Applies To: SQL Server 2014, SQL Server 2016 Preview
Returns the ID number of a principal in the current database. For more information about principals, see Principals (Database Engine).
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
Is an expression of type sysname that represents the principal.
When principal_name is omitted, the ID of the current user is returned. The parentheses are required.
NULL when the database principal does not exist
DATABASE_PRINCIPAL_ID can be used in a select list, a WHERE clause, or anywhere an expression is allowed. For more information, see Expressions (Transact-SQL).
The following example returns the database principal ID of the current user.
SELECT DATABASE_PRINCIPAL_ID(); GO
The following example returns the database principal ID for the database role db_owner.
SELECT DATABASE_PRINCIPAL_ID('db_owner'); GO