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
Cannot display the 2 tables at the same time. Studio Express
Re: Cannot display the 2 tables at the same time. Studio Express
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
You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom
Re: Cannot display the 2 tables at the same time. Studio Express
I tried changing the structure of the 2 tables and then both tables appeared. Most strange.
Re: Cannot display the 2 tables at the same time. Studio Express
Thank you for the reply.
Please let us know if it happens again.
Please let us know if it happens again.