If using a dynamic writer type, it is not possible to simply put serial in there since the schema is feature driven.

The easiest way to do this, I found was to use the SQL To Run After Write feature:

For postgresql the code would be:

ALTER TABLE testing
ADD COLUMN pkid serial;
alter table testing add CONSTRAINT pk_testing PRIMARY KEY (pkid);

I am sure there is an equivalent for SQL server. It would be something like:

ALTER TABLE Parent MODIFY Identifier smallint(10) AUTO_INCREMENT;

if the internet is to be trusted.

Edit: answer by buddiebubba is better.

If using a dynamic writer type, it is not possible to simply put serial in there since the schema is feature driven.

The easiest way to do this, I found was to use the SQL To Run After Write feature:

For postgresql the code would be:

ALTER TABLE testing
ADD COLUMN pkid serial;
alter table testing add CONSTRAINT pk_testing PRIMARY KEY (pkid);

I am sure there is an equivalent for SQL server. It would be something like:

ALTER TABLE Parent MODIFY Identifier smallint(10) AUTO_INCREMENT;

if the internet is to be trusted.

If using a dynamic writer type, it is not possible to simply put serial in there since the schema is feature driven.

The easiest way to do this, I found was to use the SQL To Run After Write feature:

For postgresql the code would be:

ALTER TABLE testing
ADD COLUMN pkid serial;
alter table testing add CONSTRAINT pk_testing PRIMARY KEY (pkid);

I am sure there is an equivalent for SQL server.

If using a dynamic writer type, it is not possible to simply put serial in there since the schema is feature driven.

The easiest way to do this, I found was to use the SQL To Run After Write feature:

For postgresql the code would be:

ALTER TABLE testing
ADD COLUMN pkid serial;
alter table testing add CONSTRAINT pk_testing PRIMARY KEY (pkid);

I am sure there is an equivalent for SQL server. It would be something like:

ALTER TABLE Parent MODIFY Identifier smallint(10) AUTO_INCREMENT;

if the internet is to be trusted.