need to find out the type of an attribute 1

[samyII]

i need to find out the data-type of an attribute i.e. whether the attribute is integer,varchar etc...
i came to know that the table "syscolumns" stores this detail ,but in numerical format, which is mapped to a corresponding type. can anyone provide me with this mapping.

Or is there any other way to retrive this info. Please Help

 

[MDXer]

information_schema.columns will have the information you need.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck