I wrote: > I looked at DB2's reference page: > https://www.ibm.com/docs/en/db2/11.5?topic=statements-create-schema
Oh, how did I forget Oracle? https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/CREATE-SCHEMA.html Theirs is restricted to CREATE TABLE, CREATE VIEW, and GRANT; also this curious restriction: "The CREATE SCHEMA statement supports the syntax of these statements only as defined by standard SQL, rather than the complete syntax supported by Oracle Database." But then they say: "The order in which you list the CREATE TABLE, CREATE VIEW, and GRANT statements is unimportant. The statements within a CREATE SCHEMA statement can reference existing objects or objects you create in other statements within the same CREATE SCHEMA statement." Which certainly begs the question of how smart their re-ordering algorithm is, or what they do about ambiguity between new and existing objects. But at any rate, it looks like everybody is at least trying to do some amount of re-ordering, which makes me wonder what it is that I'm missing in the spec. That's an awful lot of effort to be expending on something that the spec doesn't seem to require. regards, tom lane
