Subject RE: [firebird-support] Use of domains, triggers
Author Alan McDonald
> Given that domains are limited in their ability to enforce column
> datatypes and default values, is there any reason to use a domain rather
> than a trigger?
>
> Any examples of when a domain is more appropriate would be appreciated.
>
> Thanks,
>
> Bill

everytime you create a column of non-domain type, the system creates a
domain whether you like it or not.
If you, on the other hand, create a domain which is used over and over, you
avoid cluttering the system tables with one domain per column.
Domains also provide for the ability to increase the size of a varchar and
have all columns which are based on the domain, increase in unison
Alan