Jun 14, 2001 #1 BD26 Technical User Joined Jun 14, 2001 Messages 1 Location 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 Joined May 29, 2001 Messages 32 Location IE Delete * from Board; This will delete all records/fields in your table. Brendan Upvote 0 Downvote
Jun 14, 2001 #3 listener22 Programmer Joined Jul 10, 2000 Messages 154 Location 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