Linked Table Type Constants (SQLDMO_LINKEDTABLE_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Linked table type constants classify OLE DB provider tables and are used to restrict result set membership when the EnumTables method of the LinkedServer object is used.
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 |
Restricts result set membership to alias tables. |
SQLDMOLinkedTable_Default |
0 |
Results set membership is not restricted. |
SQLDMOLinkedTable_GlobalTemporary |
2 |
Restricts result set membership to global temporary tables. |
SQLDMOLinkedTable_LocalTemporary |
3 |
Restricts result set membership to local temporary tables. |
SQLDMOLinkedTable_SystemTable |
4 |
Restricts result set membership to system tables. |
SQLDMOLinkedTable_SystemView |
7 |
Restricts result set membership to system views. |
SQLDMOLinkedTable_Table |
5 |
Restricts result set membership to user tables. |
SQLDMOLinkedTable_View |
6 |
Restricts result set membership to views. |