Problem with MS SQL 2000 and indexes

Ivelin Salabashev

Delphi Developer

Wed, 14 May 2003 03:00:00 GMT

Problem with MS SQL 2000 and indexes

Hi,
I have a problem when I use MS SQL 2000 in Delphi 5 (BDE 5.1.1)
I use SQLLinks driver.
The problem is with indexes.
When I create tables all indexes are retreived correctly in
TTable.IndexDefs, but after I execute any operation on any table then new
indexes appeared
For Examle: _WA_Sys_Firm_503BEA1C, where "Firm" is field from a table.
And if table has Foreign keys - these indexes disappeared.
Where is a problem?

Other Threads

1. MS-SQL 6.5 & MS-SQL 2000

2. MS-SQL 2000, recreating indexes

3. Help: Upgrading from MS SQL 6.5 to MS SQL 2000

4. ms sql 2000 sp3 problems

5. Delphi 7 + MS SQL 2000 + double-byte characters problem

6. Heterogeneous queries problem with MS SQL 2000

7. Problem with the LIKE clause in D6 and MS SQL 2000

8. Stored proc problem MS SQL 2000

9. MS SQL Server 2000 with sql links

10. Are there SQL links for MS SQL 2000 ?