 |
 |
 |
| SQL Commands | |||
| SQL DELETE Statement | |||
| The DELETE Statement | |||
| The DELETE statement is used to delete rows in a table. | |||
| Syntax | |||
|
|||
| Table name “Associate” | |||
|
|||
| Delete a Row | |||
| “Ravish” is going to be deleted. | |||
|
|||
| Result | |||
|
|||
| Delete All Rows | |||
| It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact: | |||
|
|||
|
|||
|
|||