Jun 14, 2001 #1 BD26 Technical User Jun 14, 2001 1 CA Hi, I was wondering how I can easily delete all records from my table. The SQL statement that I was trying is: Statement = DELETE from BOARD ALL "BOARD" is the name of my table. thanks in advance.
Hi, I was wondering how I can easily delete all records from my table. The SQL statement that I was trying is: Statement = DELETE from BOARD ALL "BOARD" is the name of my table. thanks in advance.
Jun 14, 2001 #2 bosully Programmer May 29, 2001 32 IE Delete * from Board; This will delete all records/fields in your table. Brendan Upvote 0 Downvote
Jun 14, 2001 #3 listener22 Programmer Jul 10, 2000 154 US or, just delete from Board; ( as long as you don't have a where clause, all records will be deleted ) Jim oracle, vb Upvote 0 Downvote
or, just delete from Board; ( as long as you don't have a where clause, all records will be deleted ) Jim oracle, vb