martyna-mindsdb
8578740c7f
* restructured docs sections into tabs * restructured docs * changes to SQL API * fixed some links
37 lines
568 B
Plaintext
37 lines
568 B
Plaintext
---
|
|
title: Remove a Table
|
|
sidebarTitle: Remove a Table
|
|
---
|
|
|
|
## Description
|
|
|
|
The `DROP TABLE` statement deletes a table or a file.
|
|
|
|
<Warning>
|
|
Please note that this feature is not yet implemented for tables from connected data sources.
|
|
</Warning>
|
|
|
|
## Syntax
|
|
|
|
Here is the syntax:
|
|
|
|
```sql
|
|
DROP TABLE table_name;
|
|
```
|
|
|
|
And for files:
|
|
|
|
```sql
|
|
DROP TABLE files.file_name;
|
|
```
|
|
|
|
On execution, we get:
|
|
|
|
```sql
|
|
Query successfully completed
|
|
```
|
|
|
|
<Note>
|
|
Please note that the uploaded files are tables as well. So to remove an uploaded file, use this `DROP TABLE` statement.
|
|
</Note>
|