PostgreSQL DELETE statement

The DETETE statement is used to delete the existing records from a table. The "WHERE" clause is used to delete the selected records, otherwise all the records would be deleted.

Syntax:

Following is the basic syntax for DELETE statement:

See this example:

Consider a table named "EMPLOYEES" having the following data.

Follow the steps given below to delete a table

• Select table "EMPLOYEES" and right click on that. You will see an option script, move your cursor over scripts, you will see "DELETE script" option. Click on that.
• You will get a page like this:

• Put the WHERE condition, which you want to delete.

Let's take an example:

Delete records from "EMPLOYEES" where "ID" is 1.

Execute the following query:

Output:

Note:If you don't use "WHERE" condition the whole records will be deleted.

See this example:

Output: