> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DROP CREDENTIAL

<a id="sql-drop-credential" />

Removes an existing [credential](/content/sql/ddl/create-credential#sql-create-credential).

```sql title="DROP CREDENTIAL Syntax" theme={null}
DROP CREDENTIAL < [<schema name>.]<credential name> | * >
```

<Info>
  All [data sources](/content/sql/ddl/create-data-source#sql-create-data-source),
  [data sinks](/content/sql/ddl/create-data-sink#sql-create-data-sink), and
  [ML container registries](/content/sql/ml#sql-ml-create-cr) that depend on a
  given *credential* must be dropped before it can be dropped.
</Info>

Only users with `system_admin` or `system_user_admin`, or users with
`credential_admin` on the *credential* to drop, may drop a *credential*.

## Parameters

<AccordionGroup>
  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* containing the *credential* to drop
  </Accordion>

  <Accordion title="<credential name>" id="<credential-name>" defaultOpen>
    Name of the existing *credential* to remove; use `*` instead of *schema*/*credential* name to
    drop all *credentials*
  </Accordion>
</AccordionGroup>

## Examples

To drop a *credential*, `auser_azure_active_dir_creds`:

```sql DROP CREDENTIAL Example theme={null}
DROP CREDENTIAL auser_azure_active_dir_creds
```