How database contents change

Changes occur to information in database tables when you submit SQL statements from client applications. Only a few SQL statements actually modify the information in a database. You can:

  • Update information in a row of a table using the UPDATE statement.
  • Delete an existing row of a table using the DELETE statement.
  • Insert a new row into a table using the INSERT statement.