Domains in SQL Server?

Question

I've just been reading 'Give us Real Domains!' on SQL Server MVP Erland Sommarskog's SQL Server Wishlist.

I was thinking of trying out CREATE TYPE with bound rules but was alarmed to learn that this is a deprecated feature.

Does SQL Server have anything resembling support for domains that is worth using? Are bound rules are worth using, considering that at least one SQL Server MVP is keeping it alive?

P.S. Don't forget to vote for Add CREATE DOMAIN command ;)

Answer 1

Seems that domain support currently found in SQL Server is not fit for purpose. Best to wait until the CREATE DOMAIN command is added ;)

Answer 2

If I'd venture a guess, data types with embedded behavior (rules, checks, constraints) are better fit for CLR UDTs. You are seeing this already in SQL Server 2008, where some new data types come as built-in CLR types like geography and geometry.