/SQL/Postgresql add not null constraint

Postgresql add not null constraint

Postgres add not null to existing column

ALTER TABLE table_name ALTER COLUMN column_name SET NOT NULL;

3

Postgresql add not null constraint

alter table users alter column email set not null;

2

Source: popsql.com

Similar codes

0 vote145 views1 answer
Remove default constraint sql server
SQL
0 vote160 views1 answer
Turnicate in mysql
SQL
0 vote159 views1 answer
Drop procedure sql
SQL
3 votes157 views1 answer
Postgresql db owner change
SQL
0 vote157 views1 answer
Pl sql join 3 tables
SQL
0 vote168 views1 answer
SQL server datetime compare
SQL
5 votes175 views1 answer
Oracle generate list of dates in between a date range
SQL
-1 vote195 views1 answer
Search all sql tables for a value
SQL
0 vote158 views1 answer
Mysql_union
SQL
0 vote195 views1 answer
Ms sql print more than 1 variable
SQL

Share