Hi Giuseppe, If you're using the code generator to produce your original schema, you can duplicate it relatively easily using:
- Runtime schema mapping: https://www.jooq.org/doc/latest/manual/code-generation/codegen-advanced/codegen-config-database/codegen-database-catalog-and-schema-mapping/ - DSLContext.ddl() and/or Meta.ddl() A more convenient syntax will be supported in the future via standard SQL CREATE TABLE (.. LIKE othertable) syntax: https://github.com/jOOQ/jOOQ/issues/8860 Or a synthetic CREATE SCHEMA .. LIKE otherschema syntax: https://github.com/jOOQ/jOOQ/issues/9527 This is a very interesting use-case to pursue in the future of jOOQ, so if you encounter any issues, please do report them. I hope this helps, Lukas On Wed, Mar 25, 2020 at 1:41 PM <iz8...@gmail.com> wrote: > Hi everyone, > > i have a question, i duplicated a table with: > > Table<?> table = DSL.table(DSL.name("dc2", "process")); > > dsl.createTable(table).as(dsl.select().from("dc1.process")).withNoData().execute(); > > but doesn't copy a primary key and foreignkey, how i do? > > and if i want to duplicate schema in jooq? thanks Giuseppe > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to jooq-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/104c349b-4add-472d-97ac-01921da2c131%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/104c349b-4add-472d-97ac-01921da2c131%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO4aROcq_JYR8-eWc7fNMNm4w%2Bw2DZUpod_TgD%2BRwguovA%40mail.gmail.com.