How can I create a table that has a primary key that consists of multiple columns? Database Table Creator allows adding multiple columns as key, but I can choose only one as primary key.
Im not sure that is possible. But I can tell you a way around it. If you use the DATABASE WRITER node, you can create a new and/or empty table. That table will have all the columns needed and you can specify the data types, nullable etc. Then use the DATABASE SQL EXECUTOR node to perform an ALTER TABLE command to add the PRIMARY KEY constraint.
That works, thank you!