View Issue Details

IDProjectCategoryView StatusLast Update
0000004Database Workbench v6Firebird Modulepublic2022-01-12 13:19
Reportersqldba Assigned To 
PrioritynormalSeverityfeatureReproducibilityalways
Status acknowledgedResolutionopen 
Summary0000004: Ability to alter a domain when it used in a constraint/column
DescriptionDatabase Workbench/Firebird does not have the ability to modify domains if it is used in a constraint. You cannot switch the underlying datatype nor change the length of the datatype. This defeats the whole purpose of using a domain.

In a production system, this would mean dropping all the constraints, modifying a new domain, and manually creating all the constraints which is very tedious.

No other database tool vendor for Firebird provides this feature (which is a very requested feature) and if Database Workbench implements this feature, it would be great.

Example:
CREATE DOMAIN test_domain VARCHAR(25);
CREATE TABLE test_table
(
   test_column test_domain NOT NULL PRIMARY KEY
);

ALTER DOMAIN test_domain VARCHAR(26); <-- Firebird throws error that the update was not successful because the domain is used in a constraint (primary key)
TagsNo tags attached.

Activities

sqldba

2011-04-28 15:58

reporter   ~0000001

Basically, instead of manually dropping the constraints, modifying the domain etc.....Database Workbench should automate the process.

Martijn Tonies

2011-11-02 10:54

administrator   ~0000034

Non-domained columns in tables also suffer from this issue.

Issue History

Date Modified Username Field Change
2011-04-28 15:57 sqldba New Issue
2011-04-28 15:58 sqldba Note Added: 0000001
2011-05-02 09:28 Martijn Tonies Status new => acknowledged
2011-11-02 10:54 Martijn Tonies Note Added: 0000034
2011-11-02 10:54 Martijn Tonies Priority urgent => normal
2011-11-02 10:54 Martijn Tonies Summary Alter domain when it used in a constraint/column => Ability to alter a domain when it used in a constraint/column
2013-12-18 16:14 Martijn Tonies Project Database Workbench v4 => Database Workbench v5
2022-01-12 13:15 Martijn Tonies Project Database Workbench v5 => ADS LogManager
2022-01-12 13:15 Martijn Tonies Category Firebird Module => @1@
2022-01-12 13:17 Martijn Tonies Project ADS LogManager => Database Workbench v6
2022-01-12 13:19 Martijn Tonies Category @1@ => Firebird Module