hi,
when i define table
create table test (t1 varchar(10) not null,
t2 varchar(10) not null default 'asdf')
and open it's definiton with SQL-Studio, i can see that column t1 is a
"not null" column but SQLStudio thinks, that column t2 does allow null.
BTW: it's impossible to specify a default value of '' (empty string)
with the alter-table dialog. The only thing i got was a "''" (string
with two apostrophs).
It's impossible to distinguish between a column with DEFAULT NULL (is
this equal to "no default" ?) and DEFAULT ''.
You should improve this by showing '' around strings and/or showing NULL
for a column with no default.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
