The following table lists the file open constants:
| Constant | Meaning |
| OPEN_READONLY | Ok for sqlite3_open_v2(). The database is opened in read-only mode. If the database does not already exist, an error is returned. |
| OPEN_READWRITE | Ok for sqlite3_open_v2(). The database is opened for reading and writing if possible, or reading only if the file is write protected by the operating system. In either case the database must already exist, otherwise an error is returned |
| OPEN_CREATE | Ok for sqlite3_open_v2(). When merged with OPEN_READWRITE, the database is opened for reading and writing, and is created if it does not already exist. |
| OPEN_DELETEONCLOSE | VFS only |
| OPEN_EXCLUSIVE | VFS only |
| OPEN_AUTOPROXY | VFS only |
| OPEN_URI | Ok for sqlite3_open_v2() |
| OPEN_MAIN_DB | VFS only |
| OPEN_TEMP_DB | VFS only |
| OPEN_TRANSIENT_DB | VFS only |
| OPEN_MAIN_JOURNAL | VFS only |
| OPEN_TEMP_JOURNAL | VFS only |
| OPEN_SUBJOURNAL | VFS only |
| OPEN_MASTER_JOURNAL | VFS only |
| OPEN_NOMUTEX | Ok for sqlite3_open_v2() |
| OPEN_FULLMUTEX | Ok for sqlite3_open_v2() |
| OPEN_SHAREDCACHE | Ok for sqlite3_open_v2() |
| OPEN_PRIVATECACHE | Ok for sqlite3_open_v2() |
| OPEN_WAL | VFS only |