FrontBase logo

FrontBase Documentation

FrontBase logo

    5. SQL 92
      5.4. FrontBase Extensions
Updated: 20-Nov-2000
Table of Contents

5.4.7. Unloading a Database

WRITE ALL OUTPUT ('<directory-name>' [, 'YES' | 'NO']);

Will write the proper SQL 92 statements to recreate the entire database into a file called schema.sql that will be created in the specified directory. If 'YES' is specified as the second argument to OUTPUT, all tables will be unloaded into flat files. Please note that 'YES' must be upper case.

To rebuild an unloaded database you need to create a new database, connect (e.g. via the FBManager application) as _SYSTEM and execute the schema.sql file.

If you have feedback or questions on this document, please send e-mail to Please reference the section number and topic. Thanks!!

©2000 FrontBase, Inc. All rights reserved.