Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Question Unanswered: [Firebird] Delete records

    I've to delete records from a table whit this query:

    DELETE FROM TABLE_NAME
    WHERE TABLE_FIELD = 'ABCDE'

    This works great but the database' file doesn't reduce the size.
    How can i reduce the size of db' file?
    thx

  2. #2
    Join Date
    Feb 2004
    Location
    Beaverton, Oregon, USA
    Posts
    11

    Re: [Firebird] Delete records

    Originally posted by giovesoft
    I've to delete records from a table whit this query:

    DELETE FROM TABLE_NAME
    WHERE TABLE_FIELD = 'ABCDE'

    This works great but the database' file doesn't reduce the size.
    How can i reduce the size of db' file?
    thx
    Backup and restore, replacing the database file.
    David Cornelius
    http://CorneliusConcepts.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •