Patrick Buchinger wrote: > hello! > > i have a simple question: is there a maximum number of allowed foreign > keys defined for a sapdb database? > > i'm using sapdb 7.3.0.34 running on linux. > > > i'm trying to add a foreign key to a table, which already > references one > table. the table which shall be referenced has one reference > to a third > table, but no other table (yet) references it. > > if you need the create-statements for the whole database i > will mail it > to the list. > > thank you, > > patrick buchinger
As I saw noone else answering: Of course there is no limit of foreign keys to be 3 or something like that. Did you check if the reason for not being able to create the foreign key may be that different 'ON DELETE' clauses are there for the same table (starting at some other, but same table)? If you did not find the problem checking the restrictions for foreign keys mentioned in the reference manual, then please provide the table definitions, primary key and index definitions and foreign key definitions for all those tables being (or should be) foreign key-dependant. Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
