How to define a DATE column as primary key in a time-series data?

KNIME Analytics Platform
4

Hi @dataHoarder, can you confirm if it would create the primary key in the db if you use a DB SQL Executor with this statement?

alter table "macro"."WRSEBAL" add primary key ("date")

(I’m assuming the case sensitivity on the schema, table and column names, but otherwise don’t include the double quotes.)

1 Like