Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_dropalias (Transact-SQL)

Removes an alias that links a user in the current database to a SQL Server login.

Important noteImportant

sp_dropalias provides compatibility with earlier versions of SQL Server. This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.SQL Server provides roles and the ability to grant permissions to roles as an alternative to using aliases.

Topic link iconTransact-SQL Syntax Conventions

sp_dropalias [ @loginame = ] 'login'

[ @loginame = ] 'login'

Is the name of the SQL Server login, Windows login, or Windows group from which the alias is to be removed. login is sysname, with no default. login must already exist.

0 (success) or 1 (failure)

Aliases enable logins to assume the identity of a user in a database, thereby gaining the permissions of that user while working in that database.

When the alias is removed, the login can no longer perform the activities associated with the user whose alias the login assumed in the current database.

sp_dropalias cannot be executed within a user-defined transaction.

Requires membership in the db_owner fixed database role.

The following example removes the alias to SQL Server login Victoria from the current database.

EXEC sp_dropalias 'Victoria'
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft