Top Description Fields Constructors Methods
org.h2.engine

public final Enum NullsDistinct

extends Enum<NullsDistinct>
implements HasSQL
Class Inheritance
All Implemented Interfaces
org.h2.util.HasSQL
Imports
org.h2.util.HasSQL
Determines how rows with NULL values in indexed columns are handled in unique indexes, unique constraints, or by unique predicate.

Field Summary

Modifier and TypeField and Description
public static final NullsDistinct
ALL_DISTINCT

NULL values of columns are distinct only if all columns have null values.

public static final NullsDistinct
DISTINCT

NULL values of columns are distinct.

public static final NullsDistinct
NOT_DISTINCT

NULL values of columns are never distinct.

Constructor Summary

AccessConstructor and Description
private
NullsDistinct()

Method Summary

Modifier and TypeMethod and Description
public StringBuilder
getSQL(StringBuilder
string builder
builder, int
formatting flags
sqlFlags)

Implements org.h2.util.HasSQL.getSQL.

Appends the SQL statement of this object to the specified builder.

public static NullsDistinct
valueOf(String name)

public static NullsDistinct[]
values()

Inherited from java.lang.Enum:
clonecompareTodescribeConstableequalsfinalizegetDeclaringClasshashCodenameordinaltoStringvalueOf

Field Detail

ALL_DISTINCTback to summary
public static final NullsDistinct ALL_DISTINCT

NULL values of columns are distinct only if all columns have null values.

DISTINCTback to summary
public static final NullsDistinct DISTINCT

NULL values of columns are distinct.

NOT_DISTINCTback to summary
public static final NullsDistinct NOT_DISTINCT

NULL values of columns are never distinct.

Constructor Detail

NullsDistinctback to summary
private NullsDistinct()

Method Detail

getSQLback to summary
public StringBuilder getSQL(StringBuilder builder, int sqlFlags)

Implements org.h2.util.HasSQL.getSQL.

Doc from org.h2.util.HasSQL.getSQL.

Appends the SQL statement of this object to the specified builder.

Parameters
builder:StringBuilder

string builder

sqlFlags:int

formatting flags

Returns:StringBuilder

the specified string builder

Annotations
@Override
valueOfback to summary
public static NullsDistinct valueOf(String name)
valuesback to summary
public static NullsDistinct[] values()