Hi

I have created a domain :

YN = CHAR(1) DEFAULT 'Y' CHECK (value in ('N','Y'))

I have created a tabele X with field AAA:

CREATE TABLE X (

AAA YN DEFAULT 'Y' NOT NULL /* YN = CHAR(1) DEFAULT 'Y' CHECK (value in
('N','Y')) */

)



I ask my self why, when I create a field from domain does not copy default
value and CHECK Constrains on new field?



TIA

Paul



[Non-text portions of this message have been removed]