Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_DbSchema_Tablexf_DbSchema_TableDatabase Schema Table Information
Public Function ReadTableSchema (
TableName As String,
DBSchema As xf_DbSchema,
Optional LocalIDColumnName As String = "",
Optional AllowNoSQLMetaData As Boolean = False
) As Boolean
Read the table schema from the database. For an Access database, use DAO. For MSSQL linked tables, use specifically named MetaData views.
TableName as String
The name of the table
DBSchema as xf_DbSchema
The DbSchema parent object
Optional LocalIDColumnName as String = ""
The name of the LocalID column (overrides the standard LocalId column name defined for table shadowing)
Optional AllowNoSQLMetaData as Boolean = False
(no description)
Call Template:
Dim b As Boolean
b = xf.DefaultSchema.TableSchema("tblSample").ReadTableSchema(TableName, DBSchema)
b = xf.DefaultSchema.TableSchema("tblSample").ReadTableSchema(TableName, DBSchema, LocalIDColumnName, AllowNoSQLMetaData)