Menu

#7 NOT NULL - Fields become UNIQUE

open
nobody
None
5
2001-09-13
2001-09-13
No

When designing a Table with some fields, which should
be "NOT NULL", saving it to Disk, and then restarting
dbdesing, the Fields now are not "NOT NULL" anymore,
but are "UNIQUE". After changing them back to "NOT
NULL" the same Problem appears.

The SQL-Output before saving and restarting dbdesign:

create table TestTable(
TestKey int not null unique primary key ,
Field1 int not null ,
Field2 int not null
);

The output after restarting:

create table TestTable(
TestKey int unique primary key ,
Field1 int unique ,
Field2 int unique
);

Discussion


Log in to post a comment.

MongoDB Logo MongoDB