How to add a columns from another table of another database

Asked Jun 29 '21 at 06:39

Active Jun 29 '21 at 06:39

Viewed 112 times

How can I add a new column to a table? This column located in another table from another database. I also need it as an 'on update cascade'. So far I have no idea how to do it.

This is an example query that adds a new columns top exist table:

ALTER TABLE Orders
ADD descriptions VARCHAR (255);

But this example refers to a hardcoded column.

asked Jun 29 '21 at 06:39

חיים חדד

4

Create a trigger in the other database to update this one? Seems a strange design... – Dale K Jun 29 '21 at 06:40
1

Why do you think it is strange? – חיים חדד Jun 29 '21 at 06:41
1

@Dale K yeah....like this post shows, you cannot have foreign keys to another database; you have to make a trigger for this https://stackoverflow.com/questions/4452132/add-foreign-key-relationship-between-two-databases – George Menoutis Jun 29 '21 at 06:41
1

Strange, because its usually harder and more complex to try and sync data that it is to query it when required. – Dale K Jun 29 '21 at 06:42
1

@Dale K - Are you suggesting using a simple query? – חיים חדד Jun 29 '21 at 06:44
2

Can you just create a `view` that joins to the table in the other database and just query the view? – Stu Jun 29 '21 at 08:22

How to add a columns from another table of another database

0 Answers0