Core Properties and Methods

Property Get AutoRefresh() As Boolean

Re-read table schema information each time it is accessed rather than caching

Property Get dbConn() As xf_DbConnect

Get the DbConnect object associated with the schema

Public Sub LoadAllTableSchemas()

Read the table schemas for all the tables in the database

Property Get ReadUserDefinedMetaData() As Boolean

Get the 'ReadUserDefinedMetaData' setting (see Init).
User metadata support not yet implemented.


Public Sub RefreshTableSchema(TableName As String)

Clear the cached schema so that the table schema is re-read next time it is accessed.

Property Get SchemaDescription() As String

Get the text description for the database schema

Public Property Get SQLConstructor() As xf_SchemaSQLConstructor

Get an SQLConstructor object initialised for use with this schema

Property Get SQLDatabaseType() As xf_SQLDatabaseTypeEnum

Get the database type: xf_SQLDatabaseType_MSAccess or xf_SQLDatabaseType_MSSQL

Public Tables As Collection

' Get Col Details for table Set objTableSchema = p_objSchema.TableSchema(TableName)