clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 648554 fiddles created (15278 in the last week).

CREATE TABLE t ( a numeric PRIMARY KEY, b numeric ) ;
 hidden batch(es)


-- We add some values, if you change the 2 and replace it with NULL, you'll later generate an error INSERT INTO t (a,b) VALUES (1, 2);
1 rows affected
 hidden batch(es)


-- That's how you add a NOT NULL constraint to column b ALTER TABLE t MODIFY (b NOT NULL) ;
 hidden batch(es)


-- And that's how you remove it ALTER TABLE t MODIFY (b NULL) ;
 hidden batch(es)