• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part V: Appendix > Deleting with SQL DELETE

Deleting with SQL DELETE

SQL’s DELETE statement deletes records and is basically the same as a Delete query created through the Access user interface. The main thing to remember is that you’re deleting the entire record, which is why the DELETE clause has no field list argument. This statement takes the form

DELETE
FROM datasource
[WHERE condition]


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint