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
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.
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
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
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' .
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
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?
>
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
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.
9 matches
Mail list logo