Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_Scripterxf_ScripterSQL Script Generation and Processing
Public Function PrintTabledefs (
Optional ShowFields As Boolean = False,
Optional UseAddlLegacyVals As Boolean = False ,
Optional StripDbo As Boolean = True,
Optional MaxLookupValsReturned As Integer = 50,
Optional ProgressTextbox As TextBox = Nothing
) As String
Return a 'brain dump' of information about all the TableDefs in the database as text. Also print the information to the debug window.
the information includes:
- table names and link data
- field types
- a list of all unique FK values actually in use where an FK relationship exists
Optional ShowFields as Boolean = False
Show the field information as well as the table information
Optional UseAddlLegacyVals as Boolean = False
Use legacy values to augment the information (no implemented)
Optional StripDbo as Boolean = True
String the 'dbo' prefix from MSSQL linked tables
Optional MaxLookupValsReturned as Integer = 50
Limit the list of FK lookup values to this many values
Optional ProgressTextbox as TextBox = Nothing
A textbox object to be used to display progress information as the function is running.
Call Template:
Dim s As String
s = xf.Scripter.PrintTabledefs()
s = xf.Scripter.PrintTabledefs(ShowFields, UseAddlLegacyVals, StripDbo, MaxLookupValsReturned, ProgressTextbox)