Small correction. What I need is syntax to get the list of tables if SQLTABLES() does not work for you. The other SQL I need is the syntax to get information on the primary key columns. For SQL Server this looks like:

SELECT
	TC.Constraint_Type,
	TC.Constraint_Name Index_Name,
	TC.Table_Name,
	CCU.Column_Name
FROM Information_Schema.Table_Constraints TC
	JOIN Information_Schema.Constraint_Column_Usage CCU
		ON TC.Constraint_Name = CCU.Constraint_Name
WHERE Constraint_Type = 'PRIMARY KEY'
ORDER BY TC.Table_Name

>Thank you very much. I have downloaded CABuilder and a version for Btrieve is exactly what I need :)
>
>Let me investigate and get back to you.
>
>Alex
>
>>Do you mean something like my CABuilder PRG does for SQL Server and Oracle? It builds a class lib with a CA subclass for each table in the DB. IF so, do you have SQL code that would retrieve meta data from BTrieve regarding the list of tables or does VFP's SQLTABLES() work for that? Secondly, do you have SQL syntax that would return the table structure data including column name, data type, column width and, if numeric, precision (# of decimals)?
>>
>>I am working on a new builder for CAs in VFP 9 that is data driven and extensible. So if this would work for you, and you can figure out the SQL, I can most likely help out.