CODEWITHSUNDEEP
sqlite
Dejan
Dejan

Reputation: 10373

Does SQLite support multiple schemas within the same database?

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)?

Upvotes: 33

Views: 21075

Answers (1)

CL.
CL.

Reputation: 180280

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.

Upvotes: 37

Related Questions