Schema (jOOQ 3.13.6 API)

All Superinterfaces:

Named, QueryPart, Serializable

All Known Implementing Classes:

SchemaImpl
```
public interface Schema
extends Named
```
A schema.
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.
Author:

Lukas Eder

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method	Description
`Catalog`	`getCatalog()`	The catalog of this schema.
`Sequence<?>`	`getSequence(String name)`	Get a sequence by its name (case-sensitive) in this schema, or `null` if no such sequence exists.
`List<Sequence<?>>`	`getSequences()`	List all sequences contained in this schema.
`Table<?>`	`getTable(String name)`	Get a table by its name (case-sensitive) in this schema, or `null` if no such table exists.
`List<Table<?>>`	`getTables()`	List all tables contained in this schema.
`UDT<?>`	`getUDT(String name)`	Get a UDT by its name (case-sensitive) in this schema, or `null` if no such UDT exists.
`List<UDT<?>>`	`getUDTs()`	List all UDTs contained in this schema.
`Stream<Sequence<?>>`	`sequenceStream()`	Stream all sequences contained in this schema.
`Stream<Table<?>>`	`tableStream()`	Stream all tables contained in this schema.
`Stream<UDT<?>>`	`udtStream()`	Stream all UDTs contained in this schema.

Methods inherited from interface org.jooq.Named
getComment, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart
equals, hashCode, toString

- Method Detail
  - getCatalog
```
Catalog getCatalog()
```
    The catalog of this schema.
  - tableStream
```
Stream<Table<?>> tableStream()
```
    Stream all tables contained in this schema.
  - getTables
```
List<Table<?>> getTables()
```
    List all tables contained in this schema.
  - getTable
```
Table<?> getTable(String name)
```
    Get a table by its name (case-sensitive) in this schema, or null if no such table exists.
  - udtStream
```
Stream<UDT<?>> udtStream()
```
    Stream all UDTs contained in this schema.
  - getUDTs
```
List<UDT<?>> getUDTs()
```
    List all UDTs contained in this schema.
  - getUDT
```
UDT<?> getUDT(String name)
```
    Get a UDT by its name (case-sensitive) in this schema, or null if no such UDT exists.
  - sequenceStream
```
Stream<Sequence<?>> sequenceStream()
```
    Stream all sequences contained in this schema.
  - getSequences
```
List<Sequence<?>> getSequences()
```
    List all sequences contained in this schema.
  - getSequence
```
Sequence<?> getSequence(String name)
```
    Get a sequence by its name (case-sensitive) in this schema, or null if no such sequence exists.