db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Date Fri, 15 Sep 2006 17:35:25 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435060 ] 
Mamta A. Satoor commented on DERBY-1839:

The page for CREATE SCHEMA rrefsqlj31580.html has following syntax
This seems to say that "schemaName", "AUTHORIZATION" and "user-name" are all mandatory on
the syntax. But looking at the examples on the same page, it seems one can create a schema
with or without all of those mandatory keywords
1)CREATE SCHEMA EMP  -- in this example, only schemaName is specified
2)CREATE SCHEMA FLIGHTS AUTHORIZATION anita -- This example adheres to the syntax above
3)CREATE SCHEMA AUTHORIZATION takumi  -- in this example, no schemaName is specified

So, should the syntax look something like following? Would appreciate someone else verifying
this new suggested syntax.

CREATE SCHEMA { [schemaName AUTHORIZATION user-name] | [schemaName] | [AUTHORIZATION user-name]}

> Doc Review Updates - Ref Manual
> -------------------------------
>                 Key: DERBY-1839
>                 URL: http://issues.apache.org/jira/browse/DERBY-1839
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions:
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>         Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements_html.zip
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review
of the Reference Manual.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message