Igor Korot wrote:
> There is a notion of system table vs. user table in the DBMS.
System tables are tables with a name beginning with "sqlite_".
> My question is: what should I do if I want to create a system table?
This is possible only by (ab)using the writable_schema pragma:
CREATE TABLE xxx(what, ever, [...]);
PRAGMA writable_schema = ON;
UPDATE sqlite_master
SET name = 'sqlite_xxx',
tbl_name = 'sqlite_xxx',
sql = replace(sql, 'xxx', 'sqlite_xxx')
WHERE name = 'xxx';
Alternatively, modify the SQLite source code.
But why would you want to do this? Now you have a table that is
not completely accessible, and that will not show up in the output
of .dump.
Regards,
Clemens
