Configure Automatically Add Alias

Many of the tables in our databases are contain a prefix such as tblCustomer, tblProduct. When I write my select with the automatically add alias option on I get the following.

	Code:
	SELECT * FROM tblCustomer tc

Ideally, I would like to configure the automatic alias function to not consider the prefix tbl. Therefore easily creating the following.

	Code:
	SELECT * FROM tblCustomer c

Is this possible?

Thanks in advance!

Sorry, that is not currently possible. However, you can always change the added alias manually or you can set SQL Assistant not to add table alias automatically.

Alternatively you can also create code snippets that use either generic aliases or create table specific code snippets, for example add a snipped named "sc" with the query referenced in your post. You can then enter the code as "sc[Ctrl+Enter]" and it will insert

	Code:
	SELECT * FROM tblCustomer c

By [Ctrl+Enter] I meant Ctrl+Enter hotkey. In fact this method of coding is much more efficient then typing full SELECT statement even using SQL Assistant prompts for keywords and object name.

Lastly, it is more efficient to choose table name in the popup appearing right after the SELECT keyword, then to type the full SELECT * FROM then pick the table.

Any possibilty of adding this capability in the future?

Also, I use a snippnet "ssf" to generate my Select * From x already ;p. Although, I will use the select [Tab] when I want the full select list.

Please take a look at the Macro-variables section in the on-line help and the example snippets using $COLUMS$ and similar macros. This way you can generate complete dynamic blocks of code for your tables, even entire stored procedures. For example a single snippet can be used to generate complete set of "get", "insert", "update", "list" procedures for an arbitrary table in one go, including comments, parameters, variables, complete SQL statements, everything...