I need to create the following table :

create table employee
(
name char(35) not null constraint n124_159,
usertype char(1) not null constraint n124_160,
ddate char(52) not null constraint n124_161)

I obtained the above create statement from a remote server using
dbschema -d <database> -t employee.

I first created the table without the constraints.

Now I am unable to add the constraint using
'Alter table employee add constraint n124_159'

How to create it ?

Also what is the meaning the constraint as given in the table?

Any suggestions will be highly appreciated.

Thanks & regards

Hi

The constraint n124_159 is internal number the the server uses to manage the constraints. Not null is not a regular constraint and can't be named by user (only unique, primary key, refernce and check can be named).

so the proper way to define this table will be:

create table employee
(
name char(35) not null ,
usertype char(1) not null ,
ddate char(52) not null )

Hope I helped
Dafna

You haven't to name the 'not null' constraint , Informix can manage