| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DROP DATABASE SCOPED CREDENTIAL (Transact-SQL) |
DROP DATABASE SCOPED CREDENTIAL (Transact-SQL) |
VanMSFT |
vanto |
08/06/2024 |
sql |
t-sql |
reference |
|
|
|
|
=azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=aps-pdw-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric |
[!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
Is 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