Sample Header Ad - 728x90

Does CUBRID have Information Schema Views?

1 vote
1 answer
54 views
**I am trying to access the Information Schema views as defined in SQL92, and cannot find any in the CUBRID RDBMS. Has CUBRID implemented this specification and how can I access them?** CUBRID version: CUBRID 10.1, manual: https://www.cubrid.org/manual/en/10.1/ **There is something called System Catalog: https://www.cubrid.org/manual/en/10.1/sql/catalog.html , is this possibly the same, and why is it not called "information_schema" as specified in the SQL92 specification?** When querying the database for my table book i get following: SELECT * FROM db_class WHERE class_name LIKE 'book'; class_name = book owner_name = DBA class_type = CLASS is_system_class = NO partitioned = NO is_reuse_oid_class = YES collation = iso88591_bin comment = **Are there no schemas in CUBRID?** Configuration configuration = new Configuration() .withJdbc(new Jdbc() .withDriver(DRIVER) .withUrl(URI)) .withGenerator(new Generator() .withGenerate(new Generate() .withDaos(true) .withImmutablePojos(true)) .withDatabase(new Database() .withName(DATABASE) // .withIncludes(".*") // .withExcludes("") .withInputSchema("jq")) .withTarget(new Target() .withPackageName(PACKAGE) .withDirectory(DIRECTORY) .withClean(true))) .withLogging(Logging.TRACE); GenerationTool.generate(configuration); **I need it for code-generation with JOOQ, what catalog/schema do I have to specify?**
Asked by Erdinc Ay (167 rep)
Aug 21, 2019, 03:17 PM
Last activity: Aug 21, 2019, 03:54 PM