Linked table type constants classify OLE DB provider tables and are used to restrict result set membership when using the EnumTables method of the LinkedServer object.
Linked table type constants implement table types as specified by OLE DB. For more information about interpreting OLE DB table types for a specific linked server, see your OLE DB provider documentation.
| Constant | Value | Description |
|---|---|---|
| SQLDMOLinkedTable_Alias | 1 | Alias |
| SQLDMOLinkedTable_Default | 0 | No restriction |
| SQLDMOLinkedTable_ GlobalTemporary |
2 | Global temporary table |
| SQLDMOLinkedTable_ LocalTemporary |
3 | Local temporary table |
| SQLDMOLinkedTable_SystemTable | 4 | System table |
| SQLDMOLinkedTable_Table | 5 | User table |
| SQLDMOLinkedTable_View | 6 | View |