How to set all columns not null while creating table

Question

I'm trying to create table which should have not null constraint for all of columns.

Is there any way to set all of columns not null instead of placing it in front of each column's name?

score 0 · Answer 1 · answered May 28 '19 at 16:36

0

Is there any way to set all of columns not null instead of placing it in front of each column's name?

No, sorry to say.

answered May 28 '19 at 16:36

O. Jones

103,626
17
118
172

M. Kanarkowski · Answer 2 · 2019-05-28T16:50:06.960

-1

Actually, there is a way to make it fast. You can type in many lines in the same type by using ALT + mouse or ALT + SHIFT + ARROWS. It's works nearly in every editor. See this post for more details. It's a very useful trick when you need to edit/add a lot of same words in consecutive lines i.e. NOT NULL as in your case.

edited May 28 '19 at 16:50

answered May 28 '19 at 16:43

M. Kanarkowski

2,155
8
14

How to set all columns not null while creating table

2 Answers2