CODEWITHSUNDEEP
sql
Yogesh Kumar
Yogesh Kumar

Reputation: 1

SQL Command (ORACLE) to add constraint with a name

What should be the sql command(oracle) to add 'NOT NULL' constraint, with a constraint name, to a column of existing table?

Upvotes: 0

Views: 34

Answers (1)

OldProgrammer
OldProgrammer

Reputation: 12179

 alter table t add constraint my_named_not_null check ( x is not null );

Upvotes: 1

Related Questions