Does Firebird Database support Schema? If so, how can I create a schema in Firebird DB through ISQL?

Question

Does Firebird Database support Schema? If so, how can I create a schema in Firebird DB through ISQL? Please help me to create schemas in Firebird DB. I have tried to retrieve schema using

AbstractDatabaseMetaData.getSchemas()

But it is always retrieving empty resultset. Can anyone please help me in retrieving schemas? At least SYSTEM schema when there is no schema.

Answer 1

Firebird currently doesn't have schemas, and therefor Jaybird doesn't return any. This complies with the JDBC specification, which says:

If a given form of metadata is not available, an empty ResultSet will be returned.

Note that Firebird does have a CREATE SCHEMA, but that is simply an alias for CREATE DATABASE.