NOTE: When prompted by the script, choose the main database file, which is the one with the file extension of “.dbev”. Two versions are provided: the first is for OS X v10.10 (Yosemite) and higher, and the second is for OS X v10.9 (Mavericks): The only things you can do with the ALTER TABLE statement in SQLite is rename a table, rename a column, and add a new column to an existing table. SQLite: Use Database Bind current sql document to the. SQLite: Quick Query Choose a database and execute a query without creating a new document. SQLite: Run Query Execute query script in the editor. SQLite: New Query Create a new untitled sqlite file. This is actually one of the few things you can do with the ALTER TABLE statement in SQLite. You can mark a document as an sqlite document adding - sqlite in the first line. Open the example script in the Script Editor application. In SQLite, you can use the ALTER TABLE statement to add a column to an existing table. Unpack the archive and place the SQLite database files into the Databases folder in your Documents folder. The script provided on this page outlines the basic technique for doing so.ĭOWNLOAD a ZIP archive of the example SQLite database and related files. SQLite is SQL server software, and includes features such as queries, data security, mobile access, NOSQL, and backup and recovery.
After reviewing the previous page about creating an SQLite database from a Numbers table, the next topic in learning how to use SQLite with Numbers, is to learn how to create a Numbers table using the content of an SQLite database.
