. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 475 RDB$DEPENDENCIES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . () | DROP CONSTRAINT}] [{TYPE }] When planning to alter a domain, its dependencies must be taken into account: whether there are table columns, any variables, input and/or output ALTER DOMAIN statement. TO name Use the TO clause to rename the domain, as long as there are no dependencies on the domain, i.e. table columns, local variables or procedure arguments referencing it. SET

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 715 Table of Contents 14 RDB$DEPENDENCIES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [{TYPE }] Example ALTER DOMAIN STORE_GRP SET DEFAULT -1; When changing a domain, its dependencies must be taken into account: whether there are table columns, any variables, input and/or output (DDL) Statements 125 TO name Use the TO clause to rename the domain, as long as there are no dependencies on the domain, i.e. table columns, local variables or procedure arguments referencing it. SET

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 19.5. SHOW DEPENdencies or SHOW DEPENdency . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . COLLATIONs DOMAINs DB DATABASE DEPENdency DEPENdencies EXCEPtions FILTERs FUNCtions GENerators GRANTs 19. Isql Show commands 58 19.5. SHOW DEPENdencies or SHOW DEPENdency SQL> SHOW {DEPENdencies | DEPENdency} object_name; These commands display all dependencies for the specified object name supplied

..................................................................................... 656 RDB$DEPENDENCIES ............................................................................................. VALID_PSQL WHERE EXISTS(SELECT * FROM RDB$DEPENDENCIES WHERE RDB$DEPENDENT_NAME = VALID_PSQL.ROUTE_NAME VALID_PSQL WHERE EXISTS(SELECT * FROM RDB$DEPENDENCIES D WHERE D.RDB$DEPENDENT_NAME = VALID_PSQL.ROUTE_NAME Дополнительные

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 16. Rebuild ICU dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . in Firebird 3. Chapter 15. Close Database Ignoring Linger Setting 36 Chapter 16. Rebuild ICU dependencies Firebird uses the ICU library for some of its collations, and for indices on fields using those -icu database_name  The -⁠icu option was introduced in Firebird 3. Chapter 16. Rebuild ICU dependencies 37 Chapter 17. Version Number The -⁠z option to gfix simply prints out the version of the Firebird

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 641 RDB$DEPENDENCIES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . rdb$valid_blr FROM rdb$triggers ) (type, name, valid) WHERE EXISTS (SELECT * from rdb$dependencies WHERE rdb$dependent_name = name AND rdb$depended_on_name = 'MYDOMAIN') /* Replace MYDOMAIN rdb$valid_blr FROM rdb$triggers) (type, name, valid) WHERE EXISTS (SELECT * FROM rdb$dependencies WHERE rdb$dependent_name = name AND rdb$depended_on_name = 'MYTABLE' AND rdb$field_name

member (@1) can refer itself only in FROM clause -104 336397226 dsql_cte_cycle CTE '@1' has cyclic dependencies -104 336397227 dsql_cte_outer_join Recursive member of CTE can't be member of an outer join Cannot delete column being used in an Integrity Constraint. -616 335544630 dependency There are @1 dependencies -616 335544674 del_last_field Last column in a table cannot be deleted -616 335544728 integ_index_deactivate

RDB$TRIGGER_NAME, RDB$VALID_BLR FROM RDB$TRIGGERS) (TYPE, NAME, VALID) WHERE EXISTS (SELECT * FROM RDB$DEPENDENCIES WHERE RDB$DEPENDENT_NAME = NAME AND RDB$DEPENDED_ON_NAME = 'MYDOMAIN') /* Замените MYDOMAIN RDB$TRIGGER_NAME, RDB$VALID_BLR FROM RDB$TRIGGERS) (TYPE, NAME, VALID) WHERE EXISTS (SELECT * FROM RDB$DEPENDENCIES WHERE RDB$DEPENDENT_NAME = NAME AND RDB$DEPENDED_ON_NAME = 'MYTABLE' AND RDB$FIELD_NAME = 'MYCOLUMN')

delete column being used in an Integrity Constraint. -616 335544630 dependency There are dependencies -616 335544674 del_last_field Last column in a table cannot be deleted -616 335544728 integ_index_deactivate

delete column being used in an Integrity Constraint. -616 335544630 dependency There are %ld dependencies -616 335544674 del_last_field Last column in a table cannot be deleted -616 335544728 integ_index_deactivate