SQLite Forum

Using SQLITE_OMIT_xxx in SQLite 3.36
Login
Rather than going the twenty questions route, could you explain how your effort to build with various OMIT options differs materially from the following<sup><b>a</b></sup>:

```
  308  make clean
  309  make sqlite3 OPTS=-DSQLITE_OMIT_VIEW
  310  history
larrybr@Bit-Bungler:~/SQLite/SqliteLib/TrunkAlt$ ./sqlite3
SQLite version 3.38.0 2022-01-08 21:50:00
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create view One as select 1;
Error: in prepare, near "view": syntax error (1)
  create view One as select 1;
         ^--- error here
sqlite>
```

----

a. Above is a screen scrape showing recent pertinent command history and a SQLite shell session which shows that SQLITE_OMIT_VIEW does work. The 'make clean' and 'make sqlite3 ...' commands completed normally without complaint.