FIELD PROPERTIES
----

SELECT DISTINCT
FD.FIELDNAME
,CASE FD.FIELDTYPE
WHEN 0 THEN 'Char'
WHEN 1 THEN 'Long Char'
WHEN 2 THEN 'NBR'
WHEN 3 THEN 'Sign'
WHEN 4 THEN 'Date'
WHEN 5 THEN 'Time'
WHEN 6 THEN 'Dttm'
WHEN 7 THEN 'Img'
WHEN 8 THEN 'Vers'
ELSE ' ' END "TYPE"
,FD.LENGTH
,FL.SHORTNAME
,FL.LONGNAME
FROM PSDBFIELD FD,
PSDBFLDLABL FL,
PSPROJECTITEM PI
WHERE FD.FIELDNAME = FL.FIELDNAME
AND PI.OBJECTVALUE1 = FD.FIELDNAME
AND PI.OBJECTTYPE = 2
AND PI.OBJECTID1 = 6
AND FD.FIELDNAME = '' *** give ur fieldname here
ORDER BY FD.FIELDNAME;

they are not mine but picked from blog http://peoplesofthelp.blogspot.com/