| title | DROP DATABASE SCOPED CREDENTIAL (Transact-SQL) | ||
|---|---|---|---|
| description | DROP DATABASE SCOPED CREDENTIAL (Transact-SQL) | ||
| author | VanMSFT | ||
| ms.author | vanto | ||
| ms.date | 05/14/2025 | ||
| ms.service | sql | ||
| ms.subservice | t-sql | ||
| ms.topic | reference | ||
| ms.custom |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
||
| monikerRange | =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=aps-pdw-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB]
Removes a database scoped credential from the server.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
DROP DATABASE SCOPED CREDENTIAL credential_name
The name of the database scoped credential to remove from the server.
To drop the secret associated with a database scoped credential without dropping the database scoped credential itself, use ALTER CREDENTIAL.
Information about database scoped credentials is visible in the sys.database_scoped_credentials catalog view.
Requires ALTER permission on the credential.
The following example removes the database scoped credential called SalesAccess.
DROP DATABASE SCOPED CREDENTIAL SalesAccess;
GO