#DB BROWSER FOR SQLITE SORT TABLE DRIVERS#
#DB BROWSER FOR SQLITE SORT TABLE UPDATE#
#DB BROWSER FOR SQLITE SORT TABLE WINDOWS 7#

Open a list of database objects that you can filter for the selected database.

Open the default query console for the corresponding data source.ĭata sources and their elements (tables and table columns) For example, if you press this shortcut on a table's name in the SELECT statement, you will see the DDL of this table (the CREATE TABLE statement). This option works for tables, views, and materialized views.

Open a table view of the object in the data editor. (The names of the data sources with active database connections are shown in bold.)ĭata sources with active connections and their elements

#DB BROWSER FOR SQLITE SORT TABLE DRIVERS#

Open the Data Sources and Drivers dialog to manage your data sources and their settings.Ĭlose the database connection for the selected data source or data sources. See also, Data sources and drivers dialog.

#DB BROWSER FOR SQLITE SORT TABLE UPDATE#

Update the view of the selected element (that is to synchronize the view of the element with its actual state in the database). Specify the properties of the data source in the Data Sources and Drivers dialog that opens. If a DDL data source is selected, you can only choose to create another data source.Ĭreate a copy of the selected data source. The list of options depends on which element is currently selected.ĭata sources and their elements. Later on I realized that instead of setting the cursor at another line one can also press the Enter key, but in my case I used the method of setting the cursor at another line.Create a new data source, role, database, schema, query console, table, column, index, or a primary or a foreign key. So I went back and typed it in again, and I think I went back and forth like this for a couple of times before I realized that I had to set the cursor at another line, before pressing Save. So after pressing Save I remember that I was surprised that my 'on delete cascade' had not been saved. During the first attempt (after which the problem occurred) I did not understand that I had to press the Enter key (or put the cursor at another line) after writing 'on delete cascade'.

I do have an idea though what could have caused it, and it is connected to my own behavior. So even if I would try again, it is unlikely that I would be able make it happen again, even on my installed version. My theory is that my behavior, when adding the 'on delete cascade' was slightly different between the two attempts. Well, as you see in my text I actually did repeat the experiment (without changing the browser version), but then everything worked. I then went back to a backup, did the whole thing again, and then everything worked, but I noticed that the 'create table' script was a little different.ĬREATE TABLE 'tblSpeechInLanguage' ( speechInLanguageID INTEGER, speechID INTEGER NOT NULL, languageID INTEGER NOT NULL, FOREIGN KEY( speechID) REFERENCES tblSpeech( speechID) on delete cascade, FOREIGN KEY( languageID) REFERENCES tblLanguage( languageID), PRIMARY KEY( speechInLanguageID) )Īs you see (as far as I can see) everything is the same in both, except for the order in which they appear (if you paste both scripts on two lines after each other in something like notepad without word wrap, you can see it more clearly). I then tested the cascade action, and everything in the table was deleted, not just those rows that should have been deleted. (Strange one that caused wrong cascaded deletes)ĬREATE TABLE 'tblSpeechInLanguage' ( speechInLanguageID INTEGER, speechID INTEGER NOT NULL, languageID INTEGER NOT NULL, FOREIGN KEY( languageID) REFERENCES tblLanguage( languageID), PRIMARY KEY( speechInLanguageID), FOREIGN KEY( speechID) REFERENCES tblSpeech( speechID) ON DELETE CASCADE ) The 'create table' script then ended up like this. I had a table with foreign keys, and added 'on delete cascade' via the function 'Modify table'.

#DB BROWSER FOR SQLITE SORT TABLE WINDOWS 7#

Today I used DB Browser for SQLite, version 3.10.1 on a windows 7 machine, and encountered what seems to be a bug, either in the SQLite browser or SQLite as such.

Db browser for sqlite sort table