>Hi,
>
>There is a way (via a VFP program) to know what indices where created for a given SQL Server or Oracle table?
>
>TIA
>
>Fernando

Fernando,
If you know the back-end you are working with, you can branch two routes to get this information.

For SQL Server:

* lnconn is a valid RDBMS connection
sqlexec(lnconn,[exec sp_helpindex 'MyTable'], 'c_indexes')

For Oracle:

* lnconn is a valid RDBMS connection
sqlexec(lnconn,[select * from user_indexes where upper(table_name) = 'MYTABLE'], 'c_indexes')

HTH.