If you do not want SQL Prompt to remember aliases that you assign, clear the Learn aliases as I type check box. For example, if SQL Prompt assigns the alias c to the table Contact, you can overwrite the c with a different alias SQL Prompt remembers this alias the next time you reference the table Contact. If you assign a different alias to a table or view name, SQL Prompt remembers the alias you assigned. The candidate list displays the learned aliases at appropriate points in your query, for example when you are typing a WHERE clause or adding additional columns to your query. When SQL Prompt assigns an alias, it remembers it for use in subsequent queries in the current query editor window. If you do not want SQL Prompt to include the AS keyword when it assigns aliases, clear the Include AS in alias definition check box. When Alias Assignment is On, SQL Prompt assigns an alias to tables and views that are referenced in a SQL statement, provided that you have specified a list of columns or * to select all columns.įor example, if you select the column FirstName and then the table Contact, SQL Prompt creates the alias c where c represents the table name Contact. To manage alias assignment, on the SQL Prompt menu in your query editor, click Options, and then click the Aliases tab. If your table or view names contain prefixes, you can set SQL Prompt so that it ignores those prefixes when assigning aliases. You can also define custom aliases for tables and views. You can set SQL Prompt so that it automatically assigns aliases to tables and views that are referenced in a SQL statement.