db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6644) Support standard syntax for altering column nullability
Date Wed, 02 Jul 2014 09:23:24 GMT
Knut Anders Hatlen created DERBY-6644:
-----------------------------------------

             Summary: Support standard syntax for altering column nullability
                 Key: DERBY-6644
                 URL: https://issues.apache.org/jira/browse/DERBY-6644
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 10.11.0.0
            Reporter: Knut Anders Hatlen
            Assignee: Knut Anders Hatlen
            Priority: Minor


Derby supports altering the nullability of a column via an ALTER TABLE statement, but the
supported syntax is different from what the SQL:2011 standard defines. We should add support
for the standard syntax as well.

The standard syntax is

  ALTER TABLE t ALTER COLUMN c SET NOT NULL
  ALTER TABLE t ALTER COLUMN c DROP NOT NULL



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message