Re: [sqlite] Test Foreign Key Column

I had to use the pragmas: # foreign_key_list # foreign_keys But also the sqlite_master table includes the command used to create each table. Foreign fields will have a REFERENCES key word. Regards, ¬Jonathan -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-b

[sqlite] A real newbie question: why brackets?

The "Chinook" SQL script for creating the database contains many commands with brackets, eg DROP TABLE IF EXISTS [Album]; What do the brackets do? I've not seen any examples with brackets, but on the other hand SQLite seems to ignore them. In other words the above statement seems to be equi

Re: [sqlite] Problem with incremental_vacuum and WAL

> After some more diagnosis I discovered that the free list is not > corrupted afterall. It's just that the showdb tool fails to work > properly with databases larger than 4Gb and since the free list trunk > pages are located beyond the 4Gb barrier it caused problems. > What is showdb? I could o

Re: [sqlite] Primary Key

Or this: CREATE TABLE TwoPrimaryKeys (id INTEGER NOT NULL, name TEXT NOT NULL, address TEXT, PRIMARY KEY (id, name)) From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jonathan Allin Sent: 30 March 2011 08:41 To: 'General Discussion of S

Re: [sqlite] Primary Key

How about this: 'CREATE TABLE TwoPrimaryFields (primaryField1 TEXT NOT NULL, primaryField2 TEXT NOT NULL, someOtherField TEXT, PRIMARY KEY (primaryField1, primaryField2)) From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andi Suhandi Sent: 30 March

Re: [sqlite] storing big numbers into NUMERIC, DECIMAL columns

FYI a while ago I wrote a Java application using the logistic equation and big integers (it's still googleable). It didn't take many iterations before differences in the 16th significant figure showed up. But a bit off-topic ;o) From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users

Re: [sqlite] SQLite IDE's

Would the diff have to do more than compare (in some nice graphical way) the two sqlite_master tables? From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Petite Abeille Sent: 22 March 2011 19:01 To: General Discussion of SQLite Database Subject: Re: [sql

Re: [sqlite] storing big numbers into NUMERIC, DECIMAL columns

Igor, Is there another way of looking at the problem by considering how Java and other libraries handle big integers and big decimals? Can you store the numeric value across sufficient cells necessary to achieve the required precision? ¬Jonathan From: sqlite-users-boun...@sqlite.or

[sqlite] Use of CHECK constraints and Triggers

c to access table names, details of table columns, and indexes. However I couldn't see any way to identify check constraints and triggers. Many thanks, ¬Jonathan Allin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.