4D v13.4

DELETE

Home

 
4D v13.4
DELETE

DELETE  


 

 

 Command DELDELETE FROM {sql_name | sql_string}

[WHERE search_condition]

The DELETE command can be used to remove all or part of the data from a table indicated by passing an sql_name or sql_string after the FROM keyword.

The optional WHERE clause is used to indicate which part of the data (those meeting the search_condition) are to be deleted. If it is not passed, all the data of the table will be removed.

A positioned DELETE statement is not supported. A CASCADE type delete is implemented in 4D, but the SET DEFAULT and SET NULL delete rules are not supported.

Example  

Here is an example that removes all the movies released in the year 2000 or previously from the MOVIES table:

DELETE FROM MOVIES
WHERE Year_of_Movie <= 2000;

 
PROPERTIES 

Product: 4D
Theme: SQL Commands

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

INSERT
search_condition
UPDATE