Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_Interactxf_InteractInteraction
Public Function DbTableIndexExists (
IndexName As String,
TableName As String,
Optional dbs As DAO.Database = Nothing
) As Boolean
Does the index of the table exist in the database ?
IndexName as String
The name of the table index
TableName as String
The name of the database table
Optional dbs as DAO.Database = Nothing
Look in this database (default to the current database)
Call Template:
Dim b As Boolean
b = xf.Interact.DbTableIndexExists(IndexName, TableName)
b = xf.Interact.DbTableIndexExists(IndexName, TableName, dbs)
See Also:
Example 1:
DbTableIndexExists("tblClinicVisit", "IX_tblClinicVisit_VisitDate")