Menu
If I look at the syntax definition of an ALTER TABLE statement, it seems to indicate that a table name can be prefixed with a schema-name. Does that mean that SQLite supports schematas (the way SQL Server does)? Or is this schema-name referring to another database (similar to MySQL)?
466
It's well known that an SQLite file only contains one database but it's not as widely known that multiple files can be loaded giving the impression of multiple schemas. ATTACH DATABASE '/path/to/file. sqlite' AS dbname; Queries to the "non-main" schema can then be referenced by name SELECT * FROM dbname.
SQLite allows multiple processes to have the database file open at once, and for multiple processes to read the database at once. When any process wants to write, it must lock the entire database file for the duration of its update. But that normally only takes a few milliseconds.
In the Oracle database system, the term database schema, which is also known as "SQL schema," has a different meaning. Here, a database can have multiple schemas (or “schemata,” if you're feeling fancy). Each one contains all the objects created by a specific database user.
The default limit is 1,024.
In SQLite, a schema name is the name of an attached database.
So it is not possible to have multiple schemata within the same database.
145
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
