DDL support: ALTER COLUMN NOT NULL

[Jefferson Poe]

hello,

from reading a couple threads around the "NOT NULL" constraint for UCanAccess, I come to the conclusion that there is a fundamental difference between HSQLDB and MS Access, in which HSQLDB forces users to deal with nulls before a NOT NULL constraint can be applied to a column.

Is the team currently considering to implement ALTER COLUMN NOT NULL ? or is this feature unplanned for the reasonable future?

[Marco Amadei]

It's unplanned because unsupported by jackcess, we can't alter the
underlying metadata structure if jackcess doesn't allow us for this

Il Mar 8 Dic 2020, 23:35 Jefferson Poe jeffersonatsafe@users.sourceforge.net ha scritto:

hello,

from reading a couple threads around the "NOT NULL" constraint for
UCanAccess, I come to the conclusion that there is a fundamental difference
between HSQLDB and MS Access, in which HSQLDB forces users to deal with
nulls before a NOT NULL constraint can be applied to a column.

Is the team currently considering to implement ALTER COLUMN NOT NULL ? or
is this feature unplanned for the reasonable future?

---

DDL support: ALTER COLUMN NOT NULL
https://sourceforge.net/p/ucanaccess/discussion/help/thread/412590e539/?limit=25#7d11

---

Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to
https://sourceforge.net/p/ucanaccess/discussion/help/

To unsubscribe from further messages, a project admin can change settings
at https://sourceforge.net/p/ucanaccess/admin/discussion/forums. Or, if
this is a mailing list, you can unsubscribe from the mailing list.

[Jefferson Poe]

thanks for confirming that Marco!