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.
Hi,
in standard SQL you would enter:
DELETE FROM TABLENAME;
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:
https://wiki.documentfoundation.org/Ask/Getting_Started