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)