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
CREATE SCHEMA schemaName AUTHORIZATION user-name
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: 10.2.2.0
>            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

        

Mime
View raw message