Subject | RE: [firebird-support] Use of domains, triggers |
---|---|
Author | Alan McDonald |
Post date | 2005-03-15T03:13:52Z |
> Given that domains are limited in their ability to enforce columneverytime you create a column of non-domain type, the system creates a
> 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
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