>>I'm creating a utility that will be used to periodically synchronize a VFP database with a SQL Server 2005 Express database (SugarCRM). As part of that I'm building a cross-reference of tables and columns between the two databases.
>>
>>In VFP9, I can connect to the SugarCRM database as sa so I can do anything I want. I believe there are system stored procedure(s) that can be used to extract schema information such as:
>>
>>- list of tables in the database
>>- list of columns of a given table
>>- values of various attributes of a column
>>
>>There seem to be literally hundreds of system stored procedures. Can someone recommend one(s) that could help me get the schema information I need?
>
>Look at INFORMATION_SCHEMA.Columns and INFORMATION_SCHEMA.Tables views.
Those should give me what I need. Thanks.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up