how to clear all records in a table

Can i clear all records of table . I was in past using foxpro there is a command called zap can erase all record of a table

  • Open table
  • Select all data records
  • Select Delete

I know this . But I Guess if there is a command

An SQL command will certainly be possible there.

For SQL someone else should answer you.


in standard SQL you would enter:


Hope that helps.

To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

Have a nice day and let’s (continue to) “Be excellent to each other!”

Ask / Getting Started: