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

How it looks

PreviewTry it here. Changes are not saved.

Table Aliases

Use short aliases (f.) vs full names.

Where to change it

See all AI settings.

SQL Comments

Include /* */ explanatory comments.

Brief Explanations

Show explanation before SQL code.

On this page

How it looksWhere to change it