SQLite

Create a Temporary Table in SQLite

by

When you create a table in SQLite, you can create it as a permanent table or as a temporary table.

When you create a table in a database that you’ve created, that would be a permanent table. A temporary table is created in the temp database.

To create a temporary table, you use the same syntax as creating a regular table. The difference is that you use either the TEMP or TEMPORARY keyword. You can also (or alternatively) prefix the table name with temp, which indicates that it will be created in the temporary database.

Read more

Attach a Database in SQLite

by

When using SQLite, you can use the ATTACH DATABASE statement to add a database file to the current database connection.

When you do this, you attach a database file name and provide a name for the database. If the file exists it will be attached with your chosen name, otherwise it will be created and attached with your chosen name.

Read more

Check your SQLite Version

by

Here are a few ways to check your version of SQLite.

Actually, you probably already saw which version you were using when you connected to SQLite.

In any case, if you found this page, maybe you need another method to check your SQLite version.

Read more