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 the OLE DB provider documentation.
| Constant | Value | Description |
|---|---|---|
| SQLDMOLinkedTable_Alias | 1 | Restrict result set membership to alias tables |
| SQLDMOLinkedTable_Default | 0 | No restriction |
| SQLDMOLinkedTable_GlobalTemporary | 2 | Restrict result set membership to global temporary tables |
| SQLDMOLinkedTable_LocalTemporary | 3 | Restrict result set membership to local temporary tables |
| SQLDMOLinkedTable_SystemTable | 4 | Restrict result set membership to system tables |
| SQLDMOLinkedTable_SystemView | 7 | Restrict result set membership to System views |
| SQLDMOLinkedTable_Table | 5 | Restrict result set membership to user tables |
| SQLDMOLinkedTable_View | 6 | Restrict result set membership to views |