Very Computer

by **Will Anderso** » Thu, 28 Jun 2001 04:25:38

A quick one...How can you can you detect if a user datatype is a user data
type. I've looked in the systypes but the "status" is not consistant.

thanks,
Will

by **Will Anderso** » Thu, 28 Jun 2001 04:34:37

I think I found it using xusertype > 257

Quote:> A quick one...How can you can you detect if a user datatype is a user data
> type. I've looked in the systypes but the "status" is not consistant.

> thanks,
> Will

by **Paurav Vor** » Thu, 28 Jun 2001 05:20:38

I don't think it gives the right result
I tried doing it against pubs database
where there are three userdefined datatypes
and your result gave me only two 'tid' and 'empid'.
Anyway you should avoid using system tables
(they can change in the next release), but instead
always use Information_Schema views.
for your purpose, try this

select distinct DOMAIN_NAME from information_schema.COLUMN_DOMAIN_USAGE

--
Paurav "Please Reply To NewsGroup"

> I think I found it using xusertype > 257

> > A quick one...How can you can you detect if a user datatype is a user
data
> > type. I've looked in the systypes but the "status" is not consistant.

> > thanks,
> > Will

by **Will Anderso** » Thu, 28 Jun 2001 06:04:46

Thanks, That's much better!

> I don't think it gives the right result
> I tried doing it against pubs database
> where there are three userdefined datatypes
> and your result gave me only two 'tid' and 'empid'.
> Anyway you should avoid using system tables
> (they can change in the next release), but instead
> always use Information_Schema views.
> for your purpose, try this

> select distinct DOMAIN_NAME from information_schema.COLUMN_DOMAIN_USAGE

> --
> Paurav "Please Reply To NewsGroup"

> > I think I found it using xusertype > 257

> > > A quick one...How can you can you detect if a user datatype is a user
> data
> > > type. I've looked in the systypes but the "status" is not consistant.

> > > thanks,
> > > Will

Very Computer

systypes, user data types

systypes, user data types

systypes, user data types

systypes, user data types

systypes, user data types