GitHub

NOT NULL statement is missing in DDL for newly created SQLite tables

I try to create a SQLite db with tables that have columns with "NOT NULL" constrains. During column creation via the GUI I check-mark the NOT NULL choice and it gets reflected in the "Columns" section ...
GitHub

SQL generated by Liquibase is not accepted by H2 because because foreign key constraint assume existence of a unique key.

Exception in thread "main" liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException ...
Simon Fraser University

CREATE TABLE Statement

is the name for the constraint being specified. The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the SAS System. Use this form ...