Devart Forums

I'm new to this so I might have it wrong.

I have a DB with about 10 tables. I wanted to split 1 table into 2 separate tables.

I used this syntax

CREATE TABLE recipes_new LIKE production.recipes;
INSERT recipes_new SELECT * FROM production.recipes;

I now have the 2 tables listed but I cannot display them both on the Studio Express Diagram. When I open the second table, the first one disappears and visa versa. I can open any other tables and they work fine. Seems that it sees the two table as only one.

Thanks Wallace

Could you please describe this in more detail providing screenshots if possible?

You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom

I tried changing the structure of the 2 tables and then both tables appeared. Most strange.

Thank you for the reply.

Please let us know if it happens again.