Get Columns types by SQL query ? 1

[fb3034]

Hello everybody,

Is there a way to get all the column types of a DB Table (varchar(x), tinyint, date, ...) with an sql query (select or whatever) ?
Thanks for any input !

-- Fab

 

[r937]

depends on the database system

the ANSI SQL way is to query the INFORMATION_SCHEMA.COLUMNS view

select column_name
, data_type
from information_schema.columns
where table_name = 'mytable'
order
by ordinal_position

r937.com | rudy.ca