Xojo Documentation Xojo Documentation

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