ElegantInsights
AI settingsTable Aliases

Table Aliases

Use short aliases (f.) vs full names.

Last updated on

Default: On · Type: On / off

Controls whether the assistant uses short table aliases (e.g. f.FaultID from Faults f) or full table names (Faults.FaultID). Aliases make multi-join queries more compact; full names can be easier to read at a glance.

What changes

On uses short aliases (f., a., ts.); Off writes the full table names (Faults., Area., TStatus.).

On (aliases)

sql
SELECT    f.FaultID AS [Ticket ID],    f.Symptom AS [Subject],    a.aareadesc AS [Customer],    ts.TStatusDesc AS [Status],    f.DateOccured AS [Date Opened]FROM Faults fJOIN Area a ON a.AArea = f.AreaIntJOIN TStatus ts ON ts.TStatus = f.StatusWHERE f.FDeleted = 0    AND f.Status <> 9    AND f.DateOccured >= @startdate    AND f.DateOccured < @enddate

Off (full names)

sql
SELECT    Faults.FaultID AS [Ticket ID],    Faults.Symptom AS [Subject],    Area.aareadesc AS [Customer],    TStatus.TStatusDesc AS [Status],    Faults.DateOccured AS [Date Opened]FROM FaultsJOIN Area ON Area.AArea = Faults.AreaIntJOIN TStatus ON TStatus.TStatus = Faults.StatusWHERE Faults.FDeleted = 0    AND Faults.Status <> 9    AND Faults.DateOccured >= @startdate    AND Faults.DateOccured < @enddate

Where to change it

Set this under Profile → Prompt settings in the app. See all AI settings.

SQL Comments

Include /* */ explanatory comments.

Brief Explanations

Show explanation before SQL code.

On this page

Where to change it