001package gudusoft.gsqlparser;
002
003
004public enum EConstraintType {
005    notnull,
006    unique,
007    primary_key,
008    foreign_key,
009    check,
010    reference,
011    default_value, // valid in sql server
012    index,//mysql,
013    key, //mysql
014    exclude, //postgresql
015    distinct,//informix
016    table_index,//sql server,snowflake
017    column_index,
018
019    /**
020     * it's a fake constraint, used only in yacc rule file, should be removed during parsing
021     */
022    fake_null,
023    fake_collate,
024    fake_identity,
025    fake_rowguidcol,
026    fake_auto_increment, //mysql
027    fake_comment, //mysql
028    fake_srid, //mysql - Spatial Reference System Identifier
029    fake_db2, //db2
030    fake_maked_with,//sql server
031    fake_fuzzy_search_index,//hana
032    fake_load_unit,//hana
033    fake_column_generated_as_expr,//hana
034    fake_column_generated_as_identity,//hana,postgresql
035    fake_default_expr,//postgresql
036    attr_deferrable,//postgresql
037    attr_not_deferrable,
038    attr_initially_deferred,
039    attr_initially_immediate,
040    cluster,//gaussDB
041    encrypted,//gaussDB
042    fake_compress_off,//sybase
043    correlation,//Vertica - functional dependency constraint
044    fake_codec,//ClickHouse - column compression codec
045    fake_materialized,//ClickHouse - MATERIALIZED column modifier
046    fake_ephemeral,//ClickHouse - EPHEMERAL column modifier
047    fake_alias,//ClickHouse - ALIAS column modifier
048    fake_flink_metadata,//Flink - METADATA [FROM 'key'] [VIRTUAL] column modifier
049    fake_exasol_disable,//Exasol - DISABLE/ENABLE constraint state on a column or constraint definition
050    fake_exasol_distribution,//Exasol - DISTRIBUTE BY / PARTITION BY table element
051    fake_exasol_like,//Exasol - LIKE table [INCLUDING ...] table element
052    fake_in_dbspace,//Sybase IQ - IN <dbspace> placement on a column or constraint
053    fake_iq_unique,//Sybase IQ - IQ UNIQUE(n) cardinality hint on a column
054    fake_column_partition,//Sybase IQ - PARTITION (p IN dbspace, ...) column placement
055    fake_encoding,//Vertica - ENCODING <encoding-type> column modifier
056    fake_accessrank,//Vertica - ACCESSRANK <integer> column modifier
057
058}