ODBCDatabase.ExtendedSchema

From Xojo Documentation

You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!

Property (As Boolean )
aDatabase.ExtendedSchema = newBooleanValue
or
BooleanValue = aDatabase.ExtendedSchema

Supported for all project types and targets.

When set to True, additional columns are returned for FieldSchema and TableSchema.

Notes

Additional columns are described below

For FieldSchema:

  • TableName
  • NonUnique
  • IndexQualifier
  • Type
  • OrdinalPosition
  • ColumnName
  • TableCatalog
  • TableSchema
  • AscOrDesc
  • Cardinality
  • Pages
  • FilterCondition

For TableSchema:

  • TableType
  • Remarks
  • TableCatalog
  • TableSchema