Subject Re: [Firebird-general] Re: CREATE DOMAIN RoomType AS CHAR(1)
Author Alexandre Benson Smith
Em 14/2/2011 21:33, Thomas escreveu:
> --- 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

On the old times when I worked with SQL Server 6.5 (circa 1998), they
have something called User Defined Datatype, if my memory serves me well....

see you !