# Revision history [back]

First it's not understood why you are having a problem with creating a table with an auto-value. Over the last few days I've created dozens for date testing (as you may realize) and have no problems:

However, I do see a problem when copying a table from an embedded DB to a split DB - the AutoValue changes to "No". You can fix this with two SQL statements. First change the field back to AutoValue:

ALTER TABLE YOURTABLENAME ALTER COLUMN YOURCOLUMNNAME SET GENERATED BY DEFAULT AS IDENTITY


Next get the highest value already in use in the table and add 1 to that for use in the next statement:

ALTER TABLE TOURTABLENAME ALTER COLUMN YOURCOLUMNNAME RESTART WITH XXX


where XXX = that highest value + 1.

First it's not understood why you are having a problem with creating a table with an auto-value. Over the last few days I've created dozens for date testing (as you may realize) and have no problems:

However, I do see a problem when copying a table from an embedded DB to a split DB - the AutoValue changes to "No". You can fix this with two SQL statements. First change the field back to AutoValue:

ALTER TABLE YOURTABLENAME ALTER COLUMN YOURCOLUMNNAME SET GENERATED BY DEFAULT AS IDENTITY


Next get the highest value already in use in the table and add 1 to that for use in the next statement:

ALTER TABLE TOURTABLENAME ALTER COLUMN YOURCOLUMNNAME RESTART WITH XXX


where XXX = that highest value + 1.