And in addition to SB's reply:
SELECT * FROM YourdataBase.INFORMATION_SCHEMA.Columns ORDER BY Table_name
>Hi all
>
>I am already getting in the table structures of the SQL database tables into a VFP utility (by bringing in an empty cursor using SQL Pass-Thru). What I require also is the default values as assigned.
>
>Is this possible?
>
>Please advise.
_______________________________________________________________
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