Assuming you want to get this information from within a VFP program, check out SQLCONNECT(), SQLTABLES(), SQLCOLUMNS() in the help files. If you need more info, you can call stored procedures in SQL Server with SQLEXEC(). For example, sp_helpindex returns a cursor with all of the index information.