Subject Re: CREATE DOMAIN RoomType AS CHAR(1)
Author Thomas
--- In Firebird-general@yahoogroups.com, "plinehan" <plinehan@...> > A far better way of course than having to define the
> same thing all over a db where such a construct is
> required - but what I'm really looking for is when it
> arrived in Oracle? I think it is there now.

No, Oracle still does not have domains (or anything similar)

Interesting enough Microsoft is deprecating the feature in SQL Server (RULEs) 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.

Thomas