Movatterモバイル変換

sequence_catalogsql_identifier

Name of the database that contains the sequence (always the current database)

sequence_schemasql_identifier

Name of the schema that contains the sequence

sequence_namesql_identifier

Name of the sequence

data_typecharacter_data

The data type of the sequence.

numeric_precisioncardinal_number

This column contains the (declared or implicit) precision of the sequence data type (see above). The precision indicates the number of significant digits. It can be expressed in decimal (base 10) or binary (base 2) terms, as specified in the columnnumeric_precision_radix.

numeric_precision_radixcardinal_number

This column indicates in which base the values in the columnsnumeric_precision andnumeric_scale are expressed. The value is either 2 or 10.

numeric_scalecardinal_number

This column contains the (declared or implicit) scale of the sequence data type (see above). The scale indicates the number of significant digits to the right of the decimal point. It can be expressed in decimal (base 10) or binary (base 2) terms, as specified in the columnnumeric_precision_radix.

start_valuecharacter_data

The start value of the sequence

minimum_valuecharacter_data

The minimum value of the sequence

maximum_valuecharacter_data

The maximum value of the sequence

incrementcharacter_data

The increment of the sequence

cycle_optionyes_or_no

YES if the sequence cycles, elseNO