Skip to content

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

Open
@dyemanov

Description

@dyemanov

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.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions