select ORDINAL_POSITION,rtrim(COLUMN_NAME),rtrim(DATA_TYPE) from information_schema.COLUMNS

where TABLE_SCHEMA=upper('dbname') and TABLE_NAME=upper('table_name' )

order by ORDINAL_POSITION