Delete

Keyword DELETE

Syntax:

    DELETE FROM table [WHERE expression]

Samples:

    alasql('DELETE FROM cities WHERE population < 100000');
    alasql('DELETE FROM star WHERE name LIKE "A%"');
    alasql('DELETE FROM countries');

To delete all records from table:

	alasql('DELETE FROM [Table A]');

To delete only selected records from table:

	var numberOfDeletedLines = alasql('DELETE FROM [Table A] WHERE field1 > 10');

OUTPUT Clause

You can use the OUTPUT clause to return the deleted data.

// Return all deleted columns
alasql('DELETE FROM cities WHERE population < 100000 OUTPUT DELETED.*');

// Return specific columns
alasql('DELETE FROM cities WHERE population < 100000 OUTPUT DELETED.name, DELETED.population');

A DELETE statement will return the amount of rows deleted by the statment.

See also: INSERT, UPDATE