/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 vote200 views1 answer
Get schema of table sql
SQL
17 votes199 views3 answers
Cast in sql server
SQL
0 vote185 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote211 views1 answer
How much space does sql server take per row
SQL
11 votes224 views1 answer
Ddl view
SQL
0 vote196 views1 answer
Sql shell psql cannot enter password
SQL
0 vote177 views1 answer
Oracle index hint multiple tables example
SQL
0 vote187 views1 answer
Alter precision
SQL
57 votes320 views6 answers
Mysql alter table add column
SQL
4 votes207 views3 answers
Mysql get column names from table
SQL

Share