Skip to content
  • Java And Other Languages
  • jOOQ and jOOλ
  • jOOQ Tuesdays and Guest Posts
  • SQL Features and Tuning
  • Thoughts on Programming

Java, SQL and jOOQ.

Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ.

Tag: query

jOOQ Tip of the Day: Discover all Primary Keys

Posted on November 14, 2014November 1, 2014 by lukaseder

We've recently encountered this interesting use-case on the jOOQ user group. How do you discover all primary keys of your schema via the jOOQ API? There are two ways: Using the generated meta data Using runtime meta data Let's see how it works: Using the generated meta data This is straightforward. If you're using Java … Continue reading jOOQ Tip of the Day: Discover all Primary Keys →

  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • More
  • Click to email a link to a friend (Opens in new window)
  • Click to print (Opens in new window)

Like this:

Like Loading...
Tagged information_schema, jooq, meta data, query, schema information4 Comments

Like this blog? Check out our the best way to write SQL in Java:

jOOQ: Get Back in Control of Your SQL

Don’t forget to follow us on Twitter

Jump to:

  • Home
  • SQL Tricks and Tuning
  • Thoughts on Programming
  • jOOQ Tuesdays and Guest Posts
  • Java and Other Languages
  • jOOQ and jOOλ

Follow Blog via Email

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,107 other subscribers

Top Posts & Pages

  • SQL IN Predicate: With IN List or With Array? Which is Faster?
  • Say NO to Venn Diagrams When Explaining JOINs
  • Selecting all Columns Except One in PostgreSQL
  • How to Write a Multiplication Aggregate Function in SQL
  • Faster SQL Pagination with jOOQ Using the Seek Method
  • How SQL DISTINCT and ORDER BY are Related
  • 10 SQL Tricks That You Didn't Think Were Possible
  • How to Find the Longest Consecutive Series of Events in SQL
  • Calling an Oracle Function with PL/SQL BOOLEAN Type from SQL
  • How to Create a Range From 1 to 10 in SQL

Recent Posts

  • 3.18.0 Release with Support for more Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0 March 8, 2023
  • How to use jOOQ’s Converters with UNION Operations March 2, 2023
  • How to Write a Derived Table in jOOQ February 24, 2023
  • The Performance Impact of SQL’s FILTER Clause February 6, 2023
  • Emulating Window Functions in MySQL 5.7 January 20, 2023
  • Why You Should Execute jOOQ Queries With jOOQ January 18, 2023
  • jOOQ’s R2DBC LoggingConnection to log all SQL statements January 17, 2023
  • When to Use jOOQ and When to Use Native SQL December 8, 2022
  • LATERAL is Your Friend to Create Local Column Variables in SQL November 4, 2022
  • Calling Procedures with Default Parameters using JDBC or jOOQ October 21, 2022
jOOQ: Get Back in Control of Your SQL

About

Learn more about jOOQ

Copyright (c) by Data Geekery GmbH.
Content is licensed CC BY-SA 3.0

 

Subscribe to this blog

↑ Back to top

 

Loading Comments...
 

    %d bloggers like this: