Hello, I have a design question regarding domains, although I don't know if it is really SAPDB specific (I've never used them before). I want the value of a certain field in a row to be checked against a predefined set of possible values. I understand domains can be used in a situation like this (defining a set of possible values). The problem is that although I know the number of elements the domain should contain as of today (two), I can't really tell if this number is going to grow in the future (five or six maximum, I'd say). AFAIK, this would require me to drop the domain and recreate it with the new set of values, which I want to avoid if the database is in production. Would an ordinary table + referential integrity be a better solution than a domain in this case? Can domains be altered without needing to drop them?
Regards, Aitor _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
