RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TSQLConnection.TableScope Property
TSQLConnection Class | TSQLConnection Members | SqlExpr Namespace | Description | See Also
Collapse All

Indicates what types of tables are returned when fetching schema information about tables.

Pascal
property TableScope: TTableScopes;
C++
__property TTableScopes TableScope;
Description

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.
 

See Also
Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!