The following is the list of basic SQL commands for an database.

  •    CREATE  - Creates a new table.
  •    ALTER    - Modifies the definition (structure, data types, and so on) of an existing table.
  •    DROP     - Permanently removes objects such as tables and fields.
  •    INSERT   - Adds a record to a table.
  •    UPDATE  - Modifies data in an existing record.
  •    SELECT   - Performs a query on a table, fecthes data/rows based on matching citeria.
  •    DELETE   - Permanently removes entries from a table.