lesson1Title

lesson2Title

lesson3Title

lesson4Title

lesson5Title

lesson6Title

lesson7Title

lesson8Title

lesson9Title

lesson10Title

lesson11Title

sqlIntroBasicChapter2Title

sqlIntroBasicChapter1Title

sqlIntroBasicChapter3Title

-- View all clients before deletion
SELECT * FROM clients;

-- Delete a client by name
DELETE FROM clients
WHERE name = 'Jason Green';

-- Check the table after deleting a client
SELECT * FROM clients;

-- Delete all records (use with caution!)
DELETE FROM clients;

-- Check the table after deleting all records
SELECT * FROM clients;

# `DELETE`

The `DELETE` statement **removes rows** from a table.

You can delete specific records or clear all data from a table while keeping its structure.

<br/>

## Basic Syntax

The example below shows how to delete a record from a table using the `DELETE` statement:

```sql title="DELETE Syntax"
DELETE FROM table_name
WHERE condition;
```

* `DELETE FROM` specifies the table.
* `WHERE` defines which rows to remove.

> *Be careful*: Omitting the `WHERE` clause *deletes every row* in the table.
<br/>

## `DELETE` Statement Example

The query below deletes the record of the client named Jason Green.

```sql title="Delete a client by name"
DELETE FROM clients
WHERE name = 'Jason Green';
```

This command deletes the record of the client named Jason Green.

<br/>

## Delete All Rows

To clear all data from a table but keep the table structure, you can use the following query:

```sql title="Delete all records"
DELETE FROM clients;
```

> *Note*: this action cannot be undone unless a backup is available.

The DELETE command is used to remove one or more records from an existing SQL table.

DELETE

Basic Syntax

DELETE Statement Example

Delete All Rows

`DELETE`

`DELETE` Statement Example