If I look at the syntax definition of an ALTER TABLE statement , it looks like the table name may have a prefix with schema-name . Does this mean that SQLite supports schemas (as SQL Server does)? Or is it a schema-name referring to another database (similar to MySQL)?
schema-name
In SQLite, the schema name is the name of the attached database .
Thus, it is not possible to have multiple schemas within the same database.