I am trying to reverse engineer a Sybase database. It's rather large so I'm selecting three tables that I know are related.
When I attempt to reverse engineer, I get the following Sybase error message :
Attempt to insert NULL value into column 3 in work table (table id : -456758); column does not allow nulls. Update fails.
Then I get a dialog box : Unable to select foreign keys.
This happens for every table I selected, so the result is I get a diagram with unrelated tables - not very helpful !
Can anyone suggest what I must be doing wrong ? It's a production database , so (i hope) the database itself is okay....
When I attempt to reverse engineer, I get the following Sybase error message :
Attempt to insert NULL value into column 3 in work table (table id : -456758); column does not allow nulls. Update fails.
Then I get a dialog box : Unable to select foreign keys.
This happens for every table I selected, so the result is I get a diagram with unrelated tables - not very helpful !
Can anyone suggest what I must be doing wrong ? It's a production database , so (i hope) the database itself is okay....