none
Difference between using or not field in delete statement RRS feed

  • Question

  • Hi all

    In practical terms what is the difference between using a field in DELETE statement

    DELETE field FROM Table;

    or

    DELETE FROM Table;

    Unfortunately there is no TRUNCATE statement in Access

    In Access 2010 (32 bits version) when I use DELETE * FROM Table; I often get the error "the database is in a format that can not be use...." or something like this. 

    Thanks


    Joao Simplicio Rodrigues


    Friday, April 27, 2018 1:36 PM

Answers

All replies

  • No difference.

    Please quote any error message VERBATIM.


    -Tom. Microsoft Access MVP

    Friday, April 27, 2018 2:15 PM
  • Tom,

    Verbatim Ok 

    and Thank you.


    Joao Simplicio Rodrigues

    Friday, April 27, 2018 4:38 PM
  • I'm not sure what the difference is other than we can't delete a specific field from a table without using ALTER.  We can only delete the whole record.  I always use DELETE FROM <table> and never had any issues either in 2007, 2010 or 2013 (now using).

    Mike

    Friday, April 27, 2018 5:22 PM