There are three constructs in SQL that allow us to update the tables of a relational database: update, insert, and delete.
The update construct modifies components of tuples. It applies to all tuples of the specified table unless limited by a where clause.