Originally Posted by Avaneesh

[sql]
select table_name,ordinal_position,column_name,data_type, is_nullable,character_maximum_length from
information_schema.columns where table_name like '%TABLENAME%'
order by ordinal_position
[b]AVANEESH[b]
[/sql]