1. Delete: Delete rows from the datasheet (you can delete a row or delete all rows without deleting the data table)
Delete a row: Delete from data table name where column name = value;
Delete all rows: Delete*from data table name
2. Drop: Delete a datasheet or database or table field
Delete database: Drop database name
Delete a data table (the structure, properties, and indexes of the table are also deleted): Use database name
drop table data table 1 name, data table 2 name
Delete a data table field (column): Use database name
ALTER TABLE data table name
Drop column field name (column name)
3. Truncate: Delete data from data table (data in data table only, not delete table)
TRUNCATE TABLE datasheet Name
Additional:
Delete data speed ranking: Drop>truncate>delete
Remove: Delete the database file
ALTER DATABASE MYDATABASE1
Remove File Mydatabase1_log
How do I distinguish a database DELETE statement from drop with delete and truncate?