How SQL Links determines if an MSSQL table can refreshed. community.borland.com Article #20580: How SQL Links determines if an MSSQL table can refreshed.


Q. How does SQL Links determine if an MSSQL Table can be refreshed or not?

A. The following query is run when the table is opened:
select x.name, x.indid, x.status, INDEX_COL('owner.tablename', x.indid, c.colid)
from sysindexes x,
syscolumns c where x.id = object_id ('owner.tablename')
and indid between 1 and 254 and x.id = c.id
and c.colid