The Empty Table <TableName> should execute an Optimize <TableName> so it gets rid of the disk space occupied by the table.

Quite often I have large tables that have a million rows. When I remove all of the rows from the table it would be nice if EDB cleaned up the file size so the drive backups are smaller. As it stands, the corresponding files for the table:  .EDBTbl, .EDBIdx, and .EDBBlb are still occupying a huge amount of disk space, around 500MB each.

I know I can write my own EmptyTable stored procedure to do it, but it would be nice if EDB did it automatically. I see no point in keeping this disk space around when the table is empty.

Thanks

Barry

Never mind.

"Empty Table" does indeed get rid of the disk space occupied by the table. I was looking at the wrong data directory of a duplicate database.

Barry
[<oops>]

Barry

Thank you for this second post

1) it gave me a good chuckle - nice way to start Monday
2) It saved me trying to figure out just when Tim changed things (EMPTY TABLE is essentially DeleteFile)


Roy Lambert