RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TAdoDbxConnectionStringBuilder.SchemaOverride Property

VCL components use this setting to scope metadata requests.

Pascal
property SchemaOverride: string;
C++
__property AnsiString SchemaOverride;

Most applications should not need to use this constant. It is provided for backwards compatibility of the dbExpress VCL. VCL components use this setting to scope metadata requests. This property should be set to user-name.override-schema-name. For example, tables created by the MSSQL sa user are placed in the dbo schema. In this case, SchemaOverride can be set to 'sa.dbo'. This causes VCL to specify the 'dbo' schema for metadata requests when a connection is made using the 'sa' user. An SQL '%' like pattern can also be used for the user-name and the override-schema-name. For example, '%.%' causes the schema to not be specified at all for all users. 

 

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!