>Hi All,
>
>I know this has been talked about before, but I can not find if I replied to it or not.
>
>I want a way to get the schema of a table and pass it back to vfp. I am going to use this to build the cursoradapter for that table on vfp side. Can someone point me to the thread, please.
>
>I believe it was talking about using the information schema table to get info, but not sure.
>
>TIA
>Beth
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'YourTableName'
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.