> For the complete documentation index, see [llms.txt](https://gyansetu-sql.gitbook.io/sql-programming/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gyansetu-sql.gitbook.io/sql-programming/sql-database/sql-drop-table-statement.md).

# DROP & TRUNCATE TABLE Statement

### The SQL DROP TABLE Statement

The DROP TABLE statement is used to drop an existing table in a database.

#### Syntax

```sql
DROP TABLE table_name;
```

> **Note:** Be careful before dropping a table. Deleting a table will result in loss of complete information stored in the table!<br>

### SQL DROP TABLE Example

The following SQL statement drops the existing table "Shippers":

```sql
DROP TABLE Shippers;
```

### SQL TRUNCATE TABLE

The TRUNCATE TABLE statement is used to delete the data inside a table, but not the table itself.

#### Syntax

```sql
TRUNCATE TABLE table_name;
```

#### Note: Truncate works as DROP and CREATE. Hence, in front end table doesn't appears to be deleted.  <br>