Thread: user data types
Hello, I have created a new data type (CREATE TYPE ...). How do I list user defined data types in particular schema? In the object tree I can't find it. (There are Tables, Functions, Sequences etc. but no Types) As I understand this is request for enhancement :)? Or am I missing something? Please CC me as I'm not subscribed. Regards, Olaf -- Olaf Frączyk <olaf@cbk.poznan.pl>
Hi, Olaf Frączyk wrote: > Hello, > > I have created a new data type (CREATE TYPE ...). > > How do I list user defined data types in particular schema? > > In the object tree I can't find it. (There are Tables, Functions, > Sequences etc. but no Types) > > As I understand this is request for enhancement :)? Or am I missing > something? Yes, they are listed where you work with them, e.g. create table and create function. Regards Tino
On 02/07/2008 11:38, Olaf Frączyk wrote: > In the object tree I can't find it. (There are Tables, Functions, > Sequences etc. but no Types) You need to go to File -> Options -> Display and check "Types". Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
On Wed, 2008-07-02 at 12:46 +0100, Raymond O'Donnell wrote: > On 02/07/2008 11:38, Olaf Frączyk wrote: > > > In the object tree I can't find it. (There are Tables, Functions, > > Sequences etc. but no Types) > > You need to go to File -> Options -> Display and check "Types". Thanks. Somebody made a mistake in Polish translation and in place of "Types" I have "Obiekty" -> "Objects" in English. Now I set English as GUI language and everything is OK :) Regards, Olaf -- Olaf Frączyk <olaf@cbk.poznan.pl>