Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » Introducing UltraLite » Introducing UltraLite » UltraLite databases


UltraLite temporary files

In addition to the database file, UltraLite creates and maintains a temporary file during database operation. You do not need to work with or maintain the file in any way.

Temporary files are only used by UltraLite and are maintained in the same file path (if one exists) as the UltraLite database itself. The temporary file has the same file name as the database, but with the following difference:

  • For file-based platforms   The tilde is included in the extension of the file. For example, if you run the CustDB.udb sample database, the temporary file called CustDB.~db is maintained in the same directory as this file.

  • For record-based platforms   The tilde is appended to the end of the name of the file. For example, if CustDB.udb existed as a record-based file for Palm OS, the temporary file for it would be maintained as CustDB.udb~.


You can safely delete the temporary file without loss of data—as long as UltraLite is not running. It does not contain information that is required across sessions.

UltraLite temporary tables