Thank you Vladimir,

That's what I needed... :)

>Hi Metin,
>
>

SELECT *
>FROM pubs.INFORMATION_SCHEMA.Columns

>This return table structures of all tables in Pubs.dbo
>
>>Hi All,
>>
>>I need to learn table structures on my sql server database. I can get it from select * from mytable but, VFP converts some field types a bit different. Example varchar type; VFP convert it to char...