[sqlite] Creating system table

2016-03-13 Thread James K. Lowden
On Sat, 12 Mar 2016 13:07:01 -0500 Igor Korot wrote: > My question is: what should I do if I want to create a system table? Change the source code? A system table differs from a user table in how it's created. User tables are defined with CREATE TABLE of course, but system tables are

[sqlite] Creating system table

2016-03-12 Thread Simon Slavin
On 12 Mar 2016, at 9:59pm, Clemens Ladisch wrote: > This is documented in the documentation: > http://www.sqlite.org/fileformat2.html#intschema To that documentation should be added sqlite_users. Simon.

[sqlite] Creating system table

2016-03-12 Thread Clemens Ladisch
Igor Korot wrote: > OK, so how many system tables SQLite has? This is documented in the documentation: http://www.sqlite.org/fileformat2.html#intschema Regards, Clemens

[sqlite] Creating system table

2016-03-12 Thread Clemens Ladisch
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

[sqlite] Creating system table

2016-03-12 Thread Simon Slavin
On 12 Mar 2016, at 6:07pm, Igor Korot wrote: > There is a notion of system table vs. user table in the DBMS. > > The SQLite has at least 1 system table that is well-known: sqlite_master. There are other tables too: the ones made by ANALYZE which have names which start with 'sqlite_stat' .

[sqlite] Creating system table

2016-03-12 Thread Keith Medcalf
dropped sqlite> > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Clemens Ladisch > Sent: Saturday, 12 March, 2016 11:42 > To: sqlite-users at mailinglists.sqli

[sqlite] Creating system table

2016-03-12 Thread Igor Korot
Hi, Clemens, On Sat, Mar 12, 2016 at 1:41 PM, Clemens Ladisch wrote: > 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? >

[sqlite] Creating system table

2016-03-12 Thread Igor Korot
Hi, Simon, On Sat, Mar 12, 2016 at 1:18 PM, Simon Slavin wrote: > > On 12 Mar 2016, at 6:07pm, Igor Korot wrote: > >> There is a notion of system table vs. user table in the DBMS. >> >> The SQLite has at least 1 system table that is well-known: sqlite_master. > > There are other tables too: the

[sqlite] Creating system table

2016-03-12 Thread Igor Korot
Hi, ALL, There is a notion of system table vs. user table in the DBMS. The SQLite has at least 1 system table that is well-known: sqlite_master. My question is: what should I do if I want to create a system table? Thank you.