Lukas Eder created DERBY-6812:
---------------------------------
Summary: Make "RESTRICT" an optional keyword in "DROP SEQUENCE"
Key: DERBY-6812
URL: https://issues.apache.org/jira/browse/DERBY-6812
Project: Derby
Issue Type: Improvement
Components: SQL
Affects Versions: 10.11.1.1
Reporter: Lukas Eder
Priority: Minor
Most SQL dialects that distinguish between RESTRICT and CASCADE in DDL
statements default to RESTRICT, if the flag is not explicitly specified.
Derby makes using RESTRICT mandatory in the DROP SEQUENCE statement:
https://db.apache.org/derby/docs/10.11/ref/rrefsqljdropsequence.html
It would be useful for better interoperability to make it optional as well,
given that it doesn't really add any value in this particular case.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
