Empty Database

Trinity Presbyterian church

<address>englisch: </address> <address>Hi, </address> <address>does enyone have an empty song database? </address> <address>Or how can I delete all songs together? </address> <address> be blessed </address> <address>Snoop</address> <address> </address> <address>german:</address> <address>Hallo,</address> <address>hat irgendwer eine lehre song Datenbang?</address> <address>oder wie kann ich alle Lieder zusammen löschen? </address> <address>seid behütet </address> <address>Snoop </address>

llin

Download SQLite Database Browser 1.1: http://sourceforge.net/project/showfiles.php?group_id=87946&package_id=91778 After opening the songs.olp file enter the following into the "execute SQL" tab:

delete from songs

Then click the "execute query" button.

-- Lawrence

fearfullymade

An easy way to delete all the songs is to click on the first song in the list, hold down the shift key, and then click on the last song. This will select every song. Then just hit delete and you will have an empty song database.

Mickeyj4j

fearfullymade Thanks this is a great thing to know. didn't think about that great. Now I can easily manage the database of songs, that has become bloated with duplicate ones etc, I can then export that take it to another computer remove the songs there and import the tidied up one, Thanks.