alter table alter column set default type code example
Example: postgresql add column with constraint
ALTER TABLE customers
ADD COLUMN contact_name VARCHAR NOT NULL;
ALTER TABLE customers
ADD COLUMN contact_name VARCHAR NOT NULL;