Re: Are DOMAINs part of SQL-99 standard?

From: Johann Sander <jsander_at_puc-online.de>
Date: 7 Apr 2003 23:47:24 -0700
Message-ID: <ff2b8f88.0304072247.1f404f36@posting.google.com>

Hello everybody,

so obviously establishing DOMAINs in their products is a no-seller for the big three. I don't quite understand this because DOMAINs would help with data integrity issues at (presumably) little cost.

When it comes to rating in this matter I would put SQL Server first, because they at least have rules you can tie to your own datatypes. Oracle and DB2 come in second, because you have user defined datatypes, but cannot associate them with constraints.

I think I will file a feature request with IBM. After all, it can't be in anybody's interest if their database is just SQL-99 entry compliant, can it?

Thanks, Johann Received on Tue Apr 08 2003 - 01:47:24 CDT