Thanks for your reply David, I was executing the pragma with the DB alias name like $ sqlite3 test.db SQLite version 3.31.1 2020-01-27 19:55:54 Enter ".help" for usage hints. sqlite> sqlite> attach database 'test' as test; sqlite> pragma test.page_size = 512; sqlite> pragma test.max_page_count = 1; 1 sqlite> However, without the DB alias, I can see the command is a success. Could you please let me know why it doesn't work with aliases or specific database as I believe that "pragma max_page_count = 1;" might be setting the limit on main DB. I am worried if I have multiple databases, and want to restrict the file size on a few of them only.