primaryKeyStream
Stream all primary keys contained in this schema.
Named
, QueryPart
, Serializable
LazySchema
, SchemaImpl
Standard SQL object identifiers come in 3 parts:
[catalog].[schema].[object]
. The schema is an object that groups
a set of objects, where objects can be Table
, Sequence
,
Routine
and many other types of objects.
If your RDBMS supports schemas, and jOOQ supports using schemas with your RDBMS, then generated schemas references can be used to qualify objects
Example:
// Assuming import static org.jooq.impl.DSL.*;
using(configuration)
.select(SCHEMA.ACTOR.FIRST_NAME, SCHEMA.ACTOR.LAST_NAME)
.from(SCHEMA.ACTOR)
.fetch();
Compatibility:
Database products like SQLDialect.MYSQL
and related dialects, such as
SQLDialect.MARIADB
use catalogs ("databases") instead of schemas, and
lack schema support. For historic reasons, jOOQ treats MySQL catalogs as
schemas and does not support any catalog qualifier in MySQL.
Instances can be created using DSL.schema(Name)
and overloads.
@NotNull Stream<ForeignKey<?,?>>
@Nullable Catalog
@Nullable Domain<?>
null
if no such domain exists.@Nullable Domain<?>
null
if no such domain exists.@NotNull List<ForeignKey<?,?>>
@NotNull List<ForeignKey<?,?>>
getForeignKeys(String name)
@NotNull List<ForeignKey<?,?>>
getForeignKeys(Name name)
getIndexes(String name)
getIndexes(Name name)
getPrimaryKeys(String name)
getPrimaryKeys(Name name)
@Nullable Sequence<?>
getSequence(String name)
null
if no such sequence exists.@Nullable Sequence<?>
getSequence(Name name)
null
if no such sequence exists.@Nullable Table<?>
null
if no such table exists.@Nullable Table<?>
null
if no such table exists.@Nullable UDT<?>
null
if no such UDT exists.@Nullable UDT<?>
null
if no such UDT exists.getUDTs()
getUniqueKeys(String name)
getUniqueKeys(Name name)
$name, getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName
null
if no such table exists.null
if no such table exists.null
if no such UDT exists.null
if no such UDT exists.null
if no such domain exists.null
if no such domain exists.null
if no such sequence exists.null
if no such sequence exists.