DATABASE_PRINCIPAL_ID#
Returns the ID number of a principal in the current database.
Syntax#
DATABASE_PRINCIPAL_ID ( 'principal_name' )
Arguments#
‘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.
Return types#
int
Example#
SELECT DATABASE_PRINCIPAL_ID('random_principal_name') ;