Glad to be of help ;o)
>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...
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst