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 is used to **remove rows** from a table. You can delete specific records or clear entire datasets.

<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.

> Without a `WHERE` clause, **all rows** in the table will be deleted.

<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;
```

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

<br/>

## What's Next?

Next, you'll explore different **data types** used in SQL such as `TEXT`, `INT`, and `REAL`.

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