firebird icon indicating copy to clipboard operation
firebird copied to clipboard

Support <schema element>s inside the schema definition, as per SQL specification

Open dyemanov opened this issue 6 months ago • 0 comments

So that the schema could be created together with its contents. It was mentioned in the original discussion but postponed.

<schema definition> ::=
    CREATE SCHEMA <schema name clause>
    [ <schema character set or path> ]
    [ <schema element>... ]

...

<schema element> ::=
    <table definition>
    | <view definition>
    | <domain definition>
    | <character set definition>
    | <collation definition>
    | <transliteration definition>
    | <assertion definition>
    | <trigger definition>
    | <user-defined type definition>
    | <user-defined cast definition>
    | <user-defined ordering definition>
    | <transform definition>
    | <schema routine>
    | <sequence generator definition>
    | <grant statement>
    | <role definition>

Maybe not something urgent, but worth adding some day.

dyemanov avatar Jun 26 '25 17:06 dyemanov