> is there a simple way (ie without creating and deleting datasets in an
> extra table) to use an auto_increment id field in several tables. no
> table has to have all ids, so i cannot use the field of a master table
> in childs. it seems one can use a sequence in postgresql in different
> tables. is it possible in a similar way?
"sequences" are separate objects used to generated, guess what,
sequential numbers. The actual usage of the numbers is undefined.
Auto-inc is auto-inc. Plain and simple. It's something related to
a column in a particular table. Each table can have it's own
"instance" of 1 (and only 1) auto-incrementing column.
Short answer: no.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL