Suggestions: SQL Code Complition

Suggestions # 1
===========
When I type following line of code, SQL Assi does not list out all COLUMNS name for a table after ALTER COLUMN statement.

ALTER TABLE EMPLOYEE_MASTER ALTER COLUMN ...
ALTER TABLE EMPLOYEE_MASTER DROP COLUMN ...

Suggestions # 2
===========
When I type following line of code, SQL Assi does not list out all CONSTRAINTS name for a table after ALTER CONSTRAINTS statement.

ALTER TABLE EMPLOYEE_MASTER ALTER CONSTRAINT...
ALTER TABLE EMPLOYEE_MASTER DROP CONSTRAINT...

Suggestions # 3
===========
Pl highlight PRIMARY KEY COLUMN(S) for a given table in diff color in dropdown list

That's all at the moment!
SQL Assistant is my "all time favorite tool!" after VS2008

Hi,

Thanks for your suggestions. SQL Assistant currently doesn't support column/constraint/index/default and other types of context elements in ALTER TABLE/VIEW/etc... types of statements. This is one of the areas where we can improve in future versions.

it would be great if you can list out all KEYWORDS w.r.t CREATE/ALTER/DROP statement. (alought this can be configured in options window)

Please take a look at http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=22428. Maybe that will help.