Re: [SQL] Alias to a type

2005-06-22 Thread Veikko Mäkinen
Richard Huxton wrote: Veikko Mäkinen wrote: Hey, Is it possible to create a new type as an alias to a pre-defined type? I use "USERID varchar(20)" in almost every table I have I'd like to make an alias for that type eg. CREATE DOMAIN username_string AS varchar(20); Te

[SQL] Alias to a type

2005-06-22 Thread Veikko Mäkinen
Hey, Is it possible to create a new type as an alias to a pre-defined type? I use "USERID varchar(20)" in almost every table I have I'd like to make an alias for that type eg. create type myschema.useridtype as varchar(20); I might have to alter the type some day and this way I'd have to