Check Script all indexes as CREATE INDEX statements at http://www.sqlservercentral.com/scripts/Index+Management/31652/ (free registration is required). > >Using VFP I would like to read all indexes from the SQL Server backend. Store them in a table and recreate them again on the clients machine.