Re: What is a UDT?

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Mon, 07 Jul 2003 02:12:58 GMT
Message-ID: <3F08D551.88D2037C@telusplanet.net>

Database
Principals, Programming and Performance
by O'Neil and O'Neil
2nd Ed: ISBN 1-55860-438-3)

UDT = User Defined Type
UDF = User Defined Function

According to the book (page 6), this is an ANSI SQL-99 term as well as a DB2-UDB term. Equates to Oracle's 'Object type' and Informix' 'row type'.

I remember using it in some of my design documentation around '92/3. IIRC, Yourdon coined it in a paper around '89 Received on Sun Jul 06 2003 - 21:12:58 CDT