To delete records in a table, use the DELETE statement with the WHERE clause to specify the condition for deletion.

• Use the DELETE statement followed by the table name

• Add the WHERE clause to specify th...read more

delete from tablename or truncate table tablename

We want delete the record this is the syntax

Truncate Table table name