Question
Joao Palma · Aug 21, 2020

IRIS SQL Linked Table

Hi everyone

Anyone knows how can we add a column to an existing linked table in Cache to reflect the external SQL table?

I've tried different queries. It does not fail but does not add the column either...

0
0 284
Discussion (4)2
Log in or sign up to continue

That's not ideal for me a I would have to drop the table first.

Hello Joao,

You should be able to edit the linked table's class definition, but reimporting it should be the safest approach.

Please note that linked tables don't actually persist the data locally, but simply define the metadata for the remote table.

I would suggest backing up your linked table class definition first.

Sincerely,

Asaf   

Great. Thank you both.

I will do this next time.

- Backup class

- Drop table

- Reimport table

Best Regards,

Joao