Question

define a primary key for a Access Datenbank before Writting

  • 6 February 2023
  • 1 reply
  • 23 views

Badge

Hello FME Community,

I want to create an access database from my tables.

When creating the database, some columns must be defined as primary keys. I want to know how can I define column in FME as primary key before writing.

 

 


1 reply

Badge +6

Hi @arash_hokm​, you can do this either in your writer or by using a FeatureWriter. In either case, go into the parameters and then into the User Attributes tab. You can then use the Index column to set the attribute you'd like as PrimaryKey. You can find more detail in this article. I hope this helps!

Reply