>Hi all,
>
>Is there an equivalent function in SQL7 to VFPs AFIELDS()?
>
>Thanks...
>
>Keith
Although it won't return an array, you can try:
Select * From information_schema.columns Where table_name='mytable'
If you are using SPT there is also SQLTABLES() and SQLCOLUMNS()
HTH