# DELETE

> DELETE in StackQL: remove an instance or instances of a cloud or SaaS resource with a SQL statement, taking the required parameters from the WHERE clause.

Source: https://stackql.io/language-spec/delete

Deletes an instance or instances of a resource. 

See also:  
[[ StackQL Resource Hierarchy ]](/getting-started/resource-hierarchy)

* * * 

## Syntax

*deleteStatement::=*

   
   

```sql
DELETE FROM <multipartIdentifier>
WHERE <expression> ;
```

* * *

## Examples

### Basic `DELETE` Statement
Run a basic DELETE statement to remove a deployed resource in an authenticated session.

```sql
-- Delete a Compute Engine resource instance by name
DELETE FROM google.compute.instances 
WHERE instance = 'demo-instance-1' 
AND project = 'stackql-demo' AND zone = 'australia-southeast1-a';
```