Data.SqlExpr.TSQLConnection.TableScope
| [–] Properties | |
|---|---|
| Type: property | |
| Visibility: published | |
| Source: Data.SqlExpr.pas Data.SqlExpr.hpp
| |
| Unit: Data.SqlExpr | |
| Parent: TSQLConnection | |
Delphi
property TableScope: TTableScopes read FTableScope write FTableScope default [tsTable, tsView];
C++
__property TTableScopes TableScope = {read=FTableScope, write=FTableScope, default=12};
Description
Indicates what types of tables are returned when fetching schema information about tables.
Set TableScope to determine the type of tables listed by the GetTableNames method or that populate an SQL dataset after calling its SetSchemaInfo method with a parameter of stTables. TableScope lets you request information about a combination of table types. By default, TableScope requests only ordinary tables and views (tsTable and tsView).
Note: TableScope only affects GetTableNames when the SystemTables parameter is false and only affects SetSchemaInfo when the SchemaType parameter is stTables. If an application calls GetTablesNames with SystemTables set to true, or calls SetSchemaInfo with SchemaType set to stSysTables, system tables, and only system tables are returned, regardless of the value of TableScope.