Subject RE: Domains... Re: [firebird-support] Re: Insert succesfull while violating primary key constraint
Author Alan McDonald
>
> Ja, I have recently started using domains (I've never really seen
> the need
> for them before - *embarrassed grin* - and am finding them exceptionally
> useful for this very thing.
>
> For example, every one of my tables has a field called
> "recordno", which is
> an integer field that also forms the primary key.
>
> So I just define a domain RECORDNUM INTEGER NOT NULL and bingo -
> I enforce
> the same rules wherever I use it. There are other examples as well.
>


And evertime you use this domain you save the database from making a unique
domain itself for the field you are creating.

1000 tables each with the same domain instead of 1000 system domains

Alan