| Subject | Re: CREATE DOMAIN RoomType AS CHAR(1) |
|---|---|
| Author | Thomas |
| Post date | 2011-02-14T23:42:55Z |
--- In Firebird-general@yahoogroups.com, "Thomas" <IJFQSFTGESJU@...> wrote:
SQL Server's CREATE TYPE is more or less a DOMAIN. The only limitation is that you cannot attach an arbitary check constraint to it. Only a NOT NULL constraint.
And H2 Database also offers DOMAINs (scoring 3:1 for OpenSource ;) )
> Interesting enough Microsoft is deprecating the feature in SQL Server (RULEs)I have to correct myself:
> that could be used for simulating at least the constraints that can be attached to a domain.
> The only other database I know that supports domains is PostgreSQL.
> I couldn't find anything in the DB2 manual related to domains as well.
SQL Server's CREATE TYPE is more or less a DOMAIN. The only limitation is that you cannot attach an arbitary check constraint to it. Only a NOT NULL constraint.
And H2 Database also offers DOMAINs (scoring 3:1 for OpenSource ;) )