Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DATABASE_PRINCIPAL_ID (Transact-SQL)

DATABASE_PRINCIPAL_ID (Transact-SQL)

 

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.

Topic link icon Transact-SQL Syntax Conventions


DATABASE_PRINCIPAL_ID ( 'principal_name' )

principal_name

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.

int

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

Community Additions

ADD
Show:
© 2015 Microsoft