Is there a simple way to create a type, which is a derived from an existing
type?
I need something like
create type newID as numeric(16,0);
create table xx (tid newID,.....);
I have existing SQL, with several types defined as above.
I hope not to have to edit all occurrences of "newID".......
Note that it's not a composite type, but just an instance of an existing type.
Thanks,
Matt