TOAD COLUMN VIEW not getting updated

Toad for Oracle & DevOps Toolkit
1

Hi,

Why is that when I alter a nullable column as non nullable by creating a check
constraint ( as below ) TOAD COLUMN VIEW does not get updated.

Example.

I successfully tried to make DEPT column as non nullable using following comand.

ALTER TABLE emp1 ADD (CHECK (“DEPT” IS NOT NULL));

But TOAD COLUMN VIEW still shows that the column is nullable.Why ?

Thanks,

Shiva

image001.jpeg

2

It looks like you are in the describe window. Did you refresh it? If you press
F5 it will refresh. I think there should probably be a dedicated refresh button
in that window.

Ed

[TeamT]
image001.jpeg

3

Well … YES I am using DESCRIBE window.

Shoun’t the DESCRIBE window show a column as NOT NULL if it has been altered so
by a constraint ?

I could’t find an explicit REFRESH button on DESCRIBE window.

F5 did not help.

By the way, I am using Toad 9.7.2.5

Thanks,

Shiva.

4

In the current beta, an F5 will refresh. In 9.7, I guess you’ll have to
close and re-open the describe window.
image001.jpeg

5

I tried that but it still did not work :frowning:

Thanks,

Shiva
image001.jpeg

6

The command you are giving is just a plain old check constraint. If you want a
true “not null” type constraint, you need to do this instead:

ALTER TABLE EMP1

MODIFY( DEPT NOT NULL);
image001.jpeg