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.