Commands to manage data in an SQL database

Managing SQL Data


You can use the following commands to manage data in an SQL database:

• SELECT

  Retrieves information from a table


• UPDATE

  Modifies information in a table


• DELETE

  Removes information from a table


• INSERT INTO

  Adds new data to a table


• CREATE TABLE

  Creates a new table


• ALTER TABLE

  Modifies an existing table


• DROP TABLE

  Deletes and existing table



A key feature of relational databases is the fact that you can create

relationships between tables, which allows you to create interrelated data sets.




LX0-104 Exam Objectives (G)