is there sq lstatement to find type and size of table column

josemourinho · #1 (**permalink**) 11-08-10, 17:27

hello

i want to ask is there some way to find the type and the size of table column ?

please help

n_i · #2 (**permalink**) 11-08-10, 17:45

Syscat.columns

Cougar8000 · #3 (**permalink**) 11-09-10, 09:56

Let's not forget that you might want to download "SQL Reference Vol.1.pdf" you can find all kind of useful info in there

Rajesh1203 · #4 (**permalink**) 11-09-10, 10:04

Quote:

Originally Posted by josemourinho

hello

i want to ask is there some way to find the type and the size of table column ?

please help

if you know the table do a describe:

describe select * from TABLE_NAME;

Cougar8000 · #5 (**permalink**) 11-09-10, 10:39

really?

wouldn't be "describe table tabname"