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.