find description defined datatypes

[peac3]

I am trying to find the defined datatype "d_rate_type" whether it is varchar, numeric, integer or etc.

I select from systypes it gives me as below but does not give me above information.

name	xtype	status	xusertype	length	xprec	xscale	tdefault	domain	uid	reserved	collationid	usertype	variable	allownulls	type	printfmt	prec	scale	collation
d_rate_type	167	1	258	3	0	0	0	0	1	0	65544	258	1	0	39	NULL	3	NULL	Latin1_General_BIN

I was wondering whether you guys could help me on this one.

thanks guys,

 

[fxthoth]

Hello, try this:

select ownType.name, systemType.name, ownType.max_length, ownType.precision, ownType.scale,
	ownType.is_nullable, ownType.is_user_defined
  from sys.types as ownType
	inner join sys.types as systemType
	on ownType.system_type_id=systemType.user_type_id
where ownType.name='d_rate_type'

 

[peac3]

Hi fxthoth,

Thanks, but I found easier one, which is from programmability -> types -> user defined types

I can view every single user defined data types there.

Thanks anyway