FireDAC - TFDTable how to add FOREIGN KEY

[TaKo91 0]

Hello,

I have a TFDconnection to Sqlite database. I already have some tables in the database which are created with TFDTable->CreateTable() method. Now I would like to create a table with primary and foreign keys:

CREATE TABLE Channels (
    channel_id INTEGER PRIMARY KEY,
    task_id INTEGER,
    FOREIGN KEY (task_id) REFERENCES tasks (task_id)
);

Where can I add Primary key and Foreign key to TFDTable before I create it?

Thanks for the replies.

 

[Hans J. Ellingsgaard 20]

Use FDQuery or FDCommand component instead of a FDTable, to run that script.