MsSql and Postgres have the concept of schemas. Schemas are isolated namespaces within a database. SqlLite and MySql have no such concept. (MySql does have a SCHEMA keyword but it is a synonym for DATABASE.)

SqlStreamStore supports schemas for both mssql and postgres by way of the properties MsSqlStreamStoreSettings.Schema, MsSqlStreamStoreV3Settings.Schema and PostgresStreamStoreSettings.Schema.

The schema is created automatically when calling CreateSchemaIfNotExists() but not included in the script returned by GetSchemaCreationScript() This means the schema must be created separately before executing the generated script or it will fail.

I suggest the schema creation logic be included in the generated script so it will have the same behavior as calling CreateSchemaIfNotExists() This should apply to mssql and postgres as it is not applicable to the other providers.