Class AddUniqueConstraintStatement

    • Constructor Detail

    • Method Detail

      • getCatalogName

        public String getCatalogName()
      • getSchemaName

        public String getSchemaName()
      • getTableName

        public String getTableName()
      • getColumnNames

        public String getColumnNames()
      • getConstraintName

        public String getConstraintName()
      • getTablespace

        public String getTablespace()
      • isDeferrable

        public boolean isDeferrable()
      • isInitiallyDeferred

        public boolean isInitiallyDeferred()
      • isDisabled

        public boolean isDisabled()
      • isClustered

        public boolean isClustered()
      • getForIndexName

        public String getForIndexName()
      • setForIndexName

        public void setForIndexName​(String forIndexName)
      • getForIndexSchemaName

        public String getForIndexSchemaName()
      • setForIndexSchemaName

        public void setForIndexSchemaName​(String forIndexSchemaName)
      • getForIndexCatalogName

        public String getForIndexCatalogName()
      • setForIndexCatalogName

        public void setForIndexCatalogName​(String forIndexCatalogName)
      • shouldValidate

        public boolean shouldValidate()
        In Oracle PL/SQL, the VALIDATE keyword defines whether a newly added unique constraint on a column in a table should cause existing rows to be checked to see if they satisfy the uniqueness constraint or not.
        true if ENABLE VALIDATE (this is the default), or false if ENABLE NOVALIDATE.
      • setShouldValidate

        public AddUniqueConstraintStatement setShouldValidate​(boolean shouldValidate)
        shouldValidate - - if shouldValidate is set to FALSE then the constraint will be created with the 'ENABLE NOVALIDATE' mode. This means the constraint would be created, but that no check will be done to ensure old data has valid constraints - only new data would be checked to see if it complies with the constraint logic. The default state for unique constraints is to have 'ENABLE VALIDATE' set.