• I'm new to this so please be patient. I read this article (and the related responses) and learned so much - thanks! I started looking into using them with my next task. And like several people here found that using something like udt_id or udt_user worked best for maintaining 'business' rules. Everything works great when creating new tables. The problem I've run across is that when I add columns to an existing table (in a script), the NOT NULL property and the default is ignored. Is there something I'm doing wrong or does this not work with, for example, ALTER TABLE address ADD COLUMN addr_created_by udt_user?

    Thanks,

    Angie