Method

Database_Class.TableSchema

Warning

This item was deprecated in version 2019r2. Please use Database.Tables as a replacement.

Description

Returns a RowSet with a list of all tables in the database.

Notes

TableSchema returns a RowSet with one field: TableName As String.

Sample code

The following code gets the TableSchema for the connected database and displays each table name:

' App.DB is a connected database
Dim tables As RecordSet
tables = App.DB.TableSchema

If tables <> Nil Then
  While Not tables.EOF
    MsgBox(tables.IdxField(1).StringValue)
    tables.MoveNext
  Wend
  tables.Close
End If

Compatibility

All project types on all supported operating systems.