The Better Way to Delete Physical Files
February 11, 2004 Hey, Ted
You missed a possible link between two articles in the January 14 issue! The first article is “Why SQL, Why Now,” and the second is “Deleting with a Generic File Name.”
The missing link is that, if you use SQL (to define your database) and issue the command DROP TABLE, the indexes and logical files are deleted (dropped) also! So that’s one of the many reasons why you should use SQL.
–Wim
Thanks for the advice, Wim. Several other readers wrote with similar comments.
SQL’s DROP TABLE command will indeed drop a physical file and the logical files that
… Read more