| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | 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 |
[!INCLUDE sql-asdb-asdbmi-asa-pdw]
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