Hi, is there any way in H2 database to move existing tables to different schema. For example, I have one table 'TABLE_A' with some data in default schema PUBLIC. I created new schema MY_SCHEMA and want to move TABLE_A and all of its content to schema MY_SCHEMA.
I tried: UPDATE INFORMATION_SCHEMA.TABLES SET TABLE_SCHEMA = 'MY_SCHEMA' WHERE TABLE_SCHEMA = 'PUBLIC' AND TABLE_NAME = 'TABLE_A' but I got: Feature not supported: "META"; SQL statement: [...] Thanks in advance for any help Matthew -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
