(RDB$REF_CONSTRAINTS). -293 335544535 check_cnstrnt_update Cannot update constraints (RDB$CHECK_CONSTRAINTS). -294 335544536 check_cnstrnt_del Cannot delete CHECK constraint entry (RDB$CHECK_CONSTRAINTS) -295 335544545 invld_cnstrnt_type Internal gds software consistency check (invalid RDB$CONSTRAINT_TYPE) -297 335544558 check_constraint Operation violates CHECK constraint on view or table -313 335544669 operation -402 335544427 datnotsup Data operation not supported -406 335544457 out_of_bounds Subscript out of bounds -407 335544435 nullsegkey Null segment of UNIQUE KEY -413 335544334 convert_error Conversion

(RDB$REF_CONSTRAINTS). -293 335544535 check_cnstrnt_update Cannot update constraints (RDB$CHECK_CONSTRAINTS). -294 335544536 check_cnstrnt_del Cannot delete CHECK constraint entry (RDB$CHECK_CONSTRAINTS) -295 335544545 invld_cnstrnt_type Internal gds software consistency check (invalid RDB$CONSTRAINT_TYPE) -297 335544558 check_constraint Operation violates CHECK constraint %s on view or table %s -313 335544669 dsql_count_mismatch operation -402 335544427 datnotsup Data operation not supported -406 335544457 out_of_bounds Subscript out of bounds -407 335544435 nullsegkey Null segment of UNIQUE KEY Firebird 2.0 Error Codes SQLCODE

(RDB$REF_CONSTRAINTS). -293 335544535 check_cnstrnt_update Cannot update constraints (RDB$CHECK_CONSTRAINTS). -294 335544536 check_cnstrnt_del Cannot delete CHECK constraint entry (RDB$CHECK_CONSTRAINTS) -295 335544545 invld_cnstrnt_type Internal gds software consistency check (invalid RDB$CONSTRAINT_TYPE) -297 335544558 check_constraint Operation violates CHECK constraint @1 on view or table @2 -313 336003099 upd Error Codes -402 335544427 datnotsup Data operation not supported -406 335544457 out_of_bounds Subscript out of bounds -407 335544435 nullsegkey Null segment of UNIQUE KEY -413 335544334 convert_error Conversion

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 711 RDB$CHECK_CONSTRAINTS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . from -32,768 to 32,767. SMALLINT Examples CREATE DOMAIN DFLAG AS SMALLINT DEFAULT 0 NOT NULL CHECK (VALUE=-1 OR VALUE=0 OR VALUE=1); CREATE DOMAIN RGB_VALUE AS SMALLINT; 3.1.2. INTEGER The INTEGER applied to them. For testing data in columns with floating-point data types, expressions should check using a range, for instance, BETWEEN, rather than searching for exact matches. When using these

(FOREIGN KEY) .................................................................. 119 Ограничение CHECK .................................................................................... 121 Кто может представления ............................................................................. 145 WITH CHECK OPTIONS ....................................................................................... 145 ........................................................................................ 653 RDB$CHECK_CONSTRAINTS .....................................................................................

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 473 RDB$CHECK_CONSTRAINTS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . from -32,768 to 32,767. SMALLINT Examples CREATE DOMAIN DFLAG AS SMALLINT DEFAULT 0 NOT NULL CHECK (VALUE=-1 OR VALUE=0 OR VALUE=1); CREATE DOMAIN RGB_VALUE AS SMALLINT; 3.1.2. INTEGER The INTEGER applied to them. For testing data in columns with floating-point data types, expressions should check using a range, for instance, BETWEEN, rather than searching for exact matches. When using these

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 638 RDB$CHECK_CONSTRAINTS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . von -32.768 bis 32.767. SMALLINT-Beispiele CREATE DOMAIN DFLAG AS SMALLINT DEFAULT 0 NOT NULL CHECK (VALUE=-1 OR VALUE=0 OR VALUE=1); CREATE DOMAIN RGB_VALUE AS SMALLINT; 3.1.2. INTEGER Der Datentyp Casting in eine Domäne werden alle dafür deklarierten Constraints berücksichtigt, d. h. NOT NULL- oder CHECK-Constraints. Wenn der Wert die Prüfung nicht besteht, schlägt die Umwandlung fehl. Wenn zusätzlich

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 5.1.5. IN() in CHECK constraints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 11. CHECK constraints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 15.2.2. Adding a CHECK constraint to an existing column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

System command in sub-shell SHOW